DBA Data[Home] [Help]

APPS.WIP_OPERATION_RESOURCES_PKG dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 279: FROM PO_REQUISITIONS_INTERFACE_ALL PRI,

275: AND WOR.OPERATION_SEQ_NUM = p_operation_seq_num
276: AND WOR.RESOURCE_SEQ_NUM = p_resource_seq_num)
277: AND NOT EXISTS
278: (SELECT '1'
279: FROM PO_REQUISITIONS_INTERFACE_ALL PRI,
280: WIP_OPERATION_RESOURCES WOR
281: WHERE WOR.WIP_ENTITY_ID = PRI.WIP_ENTITY_ID
282: AND WOR.ORGANIZATION_ID = PRI.DESTINATION_ORGANIZATION_ID
283: AND WOR.OPERATION_SEQ_NUM = PRI.WIP_OPERATION_SEQ_NUM

Line 328: FROM PO_REQUISITIONS_INTERFACE_ALL PRI,

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