DBA Data[Home] [Help]

APPS.WIP_SUB_OP_RESOURCES_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 269: FROM PO_REQUISITION_LINES_ALL PRL,

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

Line 315: FROM PO_REQUISITION_LINES_ALL PRL,

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