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.EAM_WORKORDER_UTIL_PKG dependencies on DUAL

Line 1046: FROM DUAL /fix for 2414244 /

1042: begin
1043:
1044: SELECT '1'
1045: into charges_exist_2
1046: FROM DUAL /*fix for 2414244 */
1047: WHERE EXISTS (SELECT '1'
1048: FROM WIP_REQUIREMENT_OPERATIONS
1049: WHERE ORGANIZATION_ID = x_org_id
1050: AND WIP_ENTITY_ID = x_wip_id

Line 1079: FROM dual

1075: -- Fix for Bug 3890165
1076:
1077: SELECT '1'
1078: INTO charges_exist_3
1079: FROM dual
1080: WHERE EXISTS (SELECT '1'
1081: FROM mtl_material_transactions_temp
1082: WHERE organization_id = x_org_id
1083: AND transaction_source_type_id = 5

Line 1097: FROM dual

1093: WHEN NO_DATA_FOUND then /* fix for the perf bug #2551622 */
1094: begin
1095: SELECT DISTINCT '1'
1096: into charges_exist_3
1097: FROM dual
1098: where EXISTS (SELECT '1'
1099: FROM WIP_OPERATION_RESOURCES
1100: WHERE ORGANIZATION_ID = x_org_id
1101: AND WIP_ENTITY_ID = x_wip_id

Line 1331: FROM DUAL /fix for 2414244 /

1327:
1328: begin
1329: SELECT '1'
1330: into charges_exist_2
1331: FROM DUAL /*fix for 2414244 */
1332: WHERE EXISTS (SELECT '1'
1333: FROM WIP_REQUIREMENT_OPERATIONS
1334: WHERE ORGANIZATION_ID = x_org_id
1335: AND WIP_ENTITY_ID = x_wip_id

Line 1362: FROM dual

1358: WHEN NO_DATA_FOUND then /* fix for the perf bug #2551622 */
1359: begin
1360: SELECT DISTINCT '1'
1361: into charges_exist_3
1362: FROM dual
1363: where EXISTS (SELECT '1'
1364: FROM WIP_OPERATION_RESOURCES
1365: WHERE ORGANIZATION_ID = x_org_id
1366: AND WIP_ENTITY_ID = x_wip_id

Line 1634: FROM dual

1630: WHEN NO_DATA_FOUND then /* fix for the perf bug #2551622 */
1631: BEGIN
1632: SELECT DISTINCT '1'
1633: into charges_exist_2
1634: FROM dual
1635: where EXISTS (SELECT '1'
1636: FROM WIP_OPERATION_RESOURCES
1637: WHERE ORGANIZATION_ID = p_org_id
1638: AND WIP_ENTITY_ID = p_wip_id

Line 1657: FROM DUAL

1653: /* Check for Move Transactions */
1654: BEGIN
1655: SELECT '1'
1656: INTO charges_exist_3
1657: FROM DUAL
1658: WHERE EXISTS (SELECT '1'
1659: FROM WIP_REQUIREMENT_OPERATIONS
1660: WHERE ORGANIZATION_ID = p_org_id
1661: AND WIP_ENTITY_ID = p_wip_id