APPS.WIP_RESOURCE_VALIDATIONS dependencies on PO_REQUISITION_LINES_ALL

Line 377: FROM PO_REQUISITION_LINES_ALL PRL

373: (PLL.QUANTITY-PLL.QUANTITY_CANCELLED))
374: AND nvl(pll.closed_code,'OPEN') <> 'FINALLY CLOSED'
375: UNION ALL
376: SELECT 'PO/REQ Linked'
377: FROM PO_REQUISITION_LINES_ALL PRL
378: WHERE PRL.WIP_ENTITY_ID = p_wip_entity_id
379: AND PRL.DESTINATION_ORGANIZATION_ID = p_organization_id
380: AND (p_operation_seq_num is NULL OR
381: PRL.WIP_OPERATION_SEQ_NUM = p_operation_seq_num)

Line 493: FROM PO_REQUISITION_LINES_ALL PRL

489: (PLL.QUANTITY-PLL.QUANTITY_CANCELLED))
490: AND nvl(pll.closed_code,'OPEN') <> 'FINALLY CLOSED'
491: UNION ALL
492: SELECT 'PO/REQ Linked'
493: FROM PO_REQUISITION_LINES_ALL PRL
494: WHERE PRL.WIP_ENTITY_ID = p_wip_entity_id
495: AND PRL.DESTINATION_ORGANIZATION_ID = p_organization_id
496: AND (p_operation_seq_num is NULL OR
497: PRL.WIP_OPERATION_SEQ_NUM = p_operation_seq_num)