APPS.WIP_UNRELEASE dependencies on WIP_OPERATION_RESOURCES

Line 60: FROM WIP_OPERATION_RESOURCES

56: WHERE ORGANIZATION_ID = x_org_id
57: AND TRANSACTION_SOURCE_TYPE_ID = 5
58: AND TRANSACTION_SOURCE_ID = x_wip_id)
59: OR EXISTS (SELECT 'X'
60: FROM WIP_OPERATION_RESOURCES
61: WHERE ORGANIZATION_ID = x_org_id
62: AND WIP_ENTITY_ID = x_wip_id
63: AND APPLIED_RESOURCE_UNITS <> 0)
64: OR EXISTS (SELECT 'X' /*Bug 5462655 - Added to check uncosted/erred out transactions in MMT. */

Line 147: FROM WIP_OPERATION_RESOURCES

143: AND REPETITIVE_SCHEDULE_ID = x_rep_id
144: AND QUANTITY_SCRAPPED <> 0)
145: OR EXISTS
146: (SELECT 'X'
147: FROM WIP_OPERATION_RESOURCES
148: WHERE ORGANIZATION_ID = x_org_id
149: AND WIP_ENTITY_ID = x_wip_id
150: AND REPETITIVE_SCHEDULE_ID = x_rep_id
151: AND APPLIED_RESOURCE_UNITS <> 0));