My Oracle Support Banner

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 DECEMBER 04, 2019

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:

Dispense UOM
Dispense Required
Tolerance Type
Upper Tolerance
Lower Tolerance
Security Tag Required
Instruction Set
Instruction Type
Instruction Number
Instruction Text
Task Attribute
Task Label
No of Signature
SOP Title
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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.