DBA Data[Home] [Help]

APPS.INV_RCV_STD_RCPT_APIS dependencies on PO_REQ_DISTRIBUTIONS

Line 650: FROM po_req_distributions

646: SELECT project_id
647: , task_id
648: INTO x_project_id
649: , x_task_id
650: FROM po_req_distributions
651: WHERE requisition_line_id = x_req_line_id;
652: END IF;
653:
654: IF (

Line 2725: FROM po_req_distributions_all prd

2721: (
2722: rsl.source_document_code = 'REQ'
2723: AND EXISTS(
2724: SELECT '1'
2725: FROM po_req_distributions_all prd
2726: WHERE prd.requisition_line_id = rsl.requisition_line_id
2727: AND Nvl(rsl.req_distribution_id,Nvl(prd.distribution_id,-999)) = Nvl(prd.distribution_id,-999)--BUG 4946182
2728: AND(
2729: p_project_id IS NULL