APPS.INV_RCV_STD_RCPT_APIS dependencies on PO_REQ_DISTRIBUTIONS

Line 616: FROM po_req_distributions

612: SELECT project_id
613: , task_id
614: INTO x_project_id
615: , x_task_id
616: FROM po_req_distributions
617: WHERE requisition_line_id = x_req_line_id;
618: END IF;
619:
620: IF (

Line 2669: FROM po_req_distributions_all prd

2665: (
2666: rsl.source_document_code = 'REQ'
2667: AND EXISTS(
2668: SELECT '1'
2669: FROM po_req_distributions_all prd
2670: WHERE prd.requisition_line_id = rsl.requisition_line_id
2671: AND Nvl(rsl.req_distribution_id,Nvl(prd.distribution_id,-999)) = Nvl(prd.distribution_id,-999)--BUG 4946182
2672: AND(
2673: p_project_id IS NULL