What is the Join Condition Between GMO_DISPENSE_CONFIG And GMO_INSTR_SET_DEFN_T and GMO_INSTR_DEFN_T Tables?
Last updated on MARCH 08, 2017
Applies to:Oracle MES for Process Manufacturing - Version 12.1.3 and later
Information in this document applies to any platform.
Unable to find the Join condition Between GMO_DISPENSE_CONFIG and (GMO_INSTR_SET_DEFN_T,GMO_INSTR_DEFN_T) tables.
We need a data extract listing the Items that have Dispensing Rules setup. Also, their dispensing setup details and instructions. Listed below are the required fields for the extract in single query:
Security Tag Required
No of Signature
We are able to idenify the columns through OAF pages, but unable to join the condtion among those queries. Please find the Queries attached.
And we are unable to find SOP columns query informaion.
And the path of the page is /oracle/apps/gmo/dispense/setup/webui/DispenseSetupCreatePG .
Please find the Responsibility Name :: MES for Process Manufacturing Administrator.
Please find the screen shots attached.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms