DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1048: FROM WIP_REQUIREMENT_OPERATIONS

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
1051: AND QUANTITY_ISSUED <> 0)
1052: OR EXISTS (SELECT '1'

Line 1333: FROM WIP_REQUIREMENT_OPERATIONS

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
1336: AND QUANTITY_ISSUED <> 0)
1337: OR EXISTS (SELECT '1'

Line 1617: FROM WIP_REQUIREMENT_OPERATIONS

1613: AND TRANSACTION_SOURCE_TYPE_ID = 5
1614: AND TRANSACTION_SOURCE_ID = p_wip_id
1615: AND rownum <=1)
1616: OR EXISTS (SELECT '1'
1617: FROM WIP_REQUIREMENT_OPERATIONS
1618: WHERE ORGANIZATION_ID = p_org_id
1619: AND WIP_ENTITY_ID = p_wip_id
1620: AND QUANTITY_ISSUED <> 0);
1621: /*

Line 1659: FROM WIP_REQUIREMENT_OPERATIONS

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
1662: AND QUANTITY_ISSUED <> 0)
1663: OR EXISTS(SELECT '1'