DBA Data[Home] [Help]

APPS.PO_RCOTOLERANCE_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 681: po_req_distributions_all prd

677: WHERE EXISTS (SELECT 'N'
678: FROM po_change_requests pcr,
679: po_change_requests pcr1,
680: po_requisition_lines_all prl,
681: po_req_distributions_all prd
682: WHERE prd.requisition_line_id = prl.requisition_line_id
683: AND pcr.change_request_group_id = p_reqgrp_id
684: AND pcr.action_type (+ ) = 'MODIFICATION'
685: AND pcr.request_status (+ ) NOT IN ('ACCEPTED',

Line 749: po_req_distributions_all prd

745: INTO l_return_val
746: FROM po_change_requests pcr,
747: po_change_requests pcr1,
748: po_requisition_lines_all prl,
749: po_req_distributions_all prd
750: WHERE prl.requisition_line_id = prd.requisition_line_id
751: AND pcr.change_request_group_id (+ ) = p_reqgrp_id
752: AND pcr.action_type (+ ) = 'MODIFICATION'
753: AND pcr.request_status (+ ) NOT IN ('ACCEPTED',