eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_REF_DESIG_PKG dependencies on DUAL

Line 18: SELECT 1 into dummy from dual

14: X_component_sequence_id NUMBER,
15: X_designator VARCHAR2) IS
16: dummy NUMBER;
17: BEGIN
18: SELECT 1 into dummy from dual
19: WHERE NOT EXISTS
20: (SELECT 1 from bom_reference_designators
21: WHERE component_sequence_id = X_component_sequence_id
22: AND component_reference_designator = X_designator

Line 90: FROM dual

86: IF rec_exist IN (0,1) THEN
87: --* If no_data_found for previous query or acd type is 1, checking current block
88: --* DISABLE record exists in the current block
89: SELECT 0 INTO disable_exist
90: FROM dual
91: WHERE NOT EXISTS
92: (SELECT 1 FROM bom_reference_designators
93: WHERE component_sequence_id = X_Component_Sequence_Id
94: AND component_reference_designator = X_Designator