What is the Join Condition Between GMO_DISPENSE_CONFIG And GMO_INSTR_SET_DEFN_T and GMO_INSTR_DEFN_T Tables? (Doc ID 2216138.1)

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.

Goal

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:

Org
Item
Dispense UOM
Dispense Required
Tolerance Type
Upper Tolerance
Lower Tolerance
Security Tag Required
Instruction Set
Instruction Type
Instruction Number
Instruction Text
Acknowledgement
Task
Task Attribute
Task Label
No of Signature
Role
SOP Title
SOP URL
SOP Category

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.
 

Solution

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