DBA Data[Home] [Help]

APPS.WIP_OPERATION_RESOURCES_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 267: FROM PO_REQUISITION_LINES_ALL PRL,

263: AND WOR.OPERATION_SEQ_NUM = p_operation_seq_num
264: AND WOR.RESOURCE_SEQ_NUM = p_resource_seq_num)
265: AND NOT EXISTS
266: (SELECT '1'
267: FROM PO_REQUISITION_LINES_ALL PRL,
268: WIP_OPERATION_RESOURCES WOR
269: WHERE WOR.WIP_ENTITY_ID = PRL.WIP_ENTITY_ID
270: AND WOR.ORGANIZATION_ID = PRL.DESTINATION_ORGANIZATION_ID
271: AND WOR.OPERATION_SEQ_NUM = PRL.WIP_OPERATION_SEQ_NUM

Line 313: FROM PO_REQUISITION_LINES_ALL PRL,

309: AND WOR.RESOURCE_SEQ_NUM = p_resource_seq_num
310: AND WOR.REPETITIVE_SCHEDULE_ID = p_rep_sched_id)
311: AND NOT EXISTS
312: (SELECT '1'
313: FROM PO_REQUISITION_LINES_ALL PRL,
314: WIP_OPERATION_RESOURCES WOR
315: WHERE WOR.WIP_ENTITY_ID = PRL.WIP_ENTITY_ID
316: AND WOR.ORGANIZATION_ID = PRL.DESTINATION_ORGANIZATION_ID
317: AND WOR.OPERATION_SEQ_NUM = PRL.WIP_OPERATION_SEQ_NUM