DBA Data[Home] [Help]

APPS.PO_RCOTOLERANCE_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 684: po_req_distributions_all prd

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

Line 752: po_req_distributions_all prd

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