DBA Data[Home] [Help]

APPS.WIP_SUB_OP_RESOURCES_PKG dependencies on PO_REQUISITIONS_INTERFACE_ALL

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