DBA Data[Home] [Help]

APPS.WIP_SUB_OP_RESOURCES_PKG dependencies on PO_REQUISITIONS_INTERFACE

Line 281: FROM PO_REQUISITIONS_INTERFACE PRI,

277: AND WOR.OPERATION_SEQ_NUM = p_operation_seq_num
278: AND WOR.RESOURCE_SEQ_NUM = p_resource_seq_num)
279: AND NOT EXISTS
280: (SELECT '1'
281: FROM PO_REQUISITIONS_INTERFACE PRI,
282: WIP_SUB_OPERATION_RESOURCES WOR
283: WHERE WOR.WIP_ENTITY_ID = PRI.WIP_ENTITY_ID
284: AND WOR.ORGANIZATION_ID = PRI.DESTINATION_ORGANIZATION_ID
285: AND WOR.OPERATION_SEQ_NUM = PRI.WIP_OPERATION_SEQ_NUM

Line 330: FROM PO_REQUISITIONS_INTERFACE_ALL PRI,

326: AND WOR.RESOURCE_SEQ_NUM = p_resource_seq_num
327: AND WOR.REPETITIVE_SCHEDULE_ID = p_rep_sched_id)
328: AND NOT EXISTS
329: (SELECT '1'
330: FROM PO_REQUISITIONS_INTERFACE_ALL PRI,
331: WIP_SUB_OPERATION_RESOURCES WOR
332: WHERE WOR.WIP_ENTITY_ID = PRI.WIP_ENTITY_ID
333: AND WOR.ORGANIZATION_ID = PRI.DESTINATION_ORGANIZATION_ID
334: AND WOR.OPERATION_SEQ_NUM = PRI.WIP_OPERATION_SEQ_NUM