APPS.PO_INTERFACE_S dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 3912: FROM PO_REQ_DISTRIBUTIONS_ALL --

3908:
3909: BEGIN
3910: SELECT MIN(DISTRIBUTION_ID)
3911: INTO x_req_dist_id
3912: FROM PO_REQ_DISTRIBUTIONS_ALL --
3913: WHERE REQUISITION_LINE_ID = interface.requisition_line_id
3914: AND PROJECT_ID IS NOT NULL
3915: AND TASK_ID IS NOT NULL;
3916: EXCEPTION

Line 3937: FROM PO_REQ_DISTRIBUTIONS_ALL --

3933: IF x_req_dist_id IS NULL THEN
3934: BEGIN
3935: SELECT MIN(DISTRIBUTION_ID)
3936: INTO x_req_dist_id
3937: FROM PO_REQ_DISTRIBUTIONS_ALL --
3938: WHERE REQUISITION_LINE_ID = interface.requisition_line_id
3939: AND PROJECT_ID IS NOT NULL;
3940: EXCEPTION
3941: WHEN OTHERS THEN

Line 3958: FROM PO_REQ_DISTRIBUTIONS_ALL --

3954: SELECT project_id
3955: ,task_id
3956: INTO x_project_id
3957: , x_task_id
3958: FROM PO_REQ_DISTRIBUTIONS_ALL --
3959: WHERE DISTRIBUTION_ID = x_req_dist_id;
3960: EXCEPTION
3961: WHEN NO_DATA_FOUND THEN
3962: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 7704: po_req_distributions_all prd

7700: nvl2(g_calculate_tax_flag, 'CREATE', null), --
7701: pdi.interface_distribution_ref --
7702: FROM po_distributions_interface pdi,
7703: po_line_locations_all poll,
7704: po_req_distributions_all prd
7705: --bug 16302602,join table po_req_distributions_all to get REQ_LINE_CURRENCY_AMOUNT
7706: WHERE pdi.interface_header_id = interface.interface_header_id
7707: AND pdi.interface_line_id = interface.interface_line_id
7708: AND poll.line_location_id = x_line_location_id --

Line 7705: --bug 16302602,join table po_req_distributions_all to get REQ_LINE_CURRENCY_AMOUNT

7701: pdi.interface_distribution_ref --
7702: FROM po_distributions_interface pdi,
7703: po_line_locations_all poll,
7704: po_req_distributions_all prd
7705: --bug 16302602,join table po_req_distributions_all to get REQ_LINE_CURRENCY_AMOUNT
7706: WHERE pdi.interface_header_id = interface.interface_header_id
7707: AND pdi.interface_line_id = interface.interface_line_id
7708: AND poll.line_location_id = x_line_location_id --
7709: AND prd.DISTRIBUTION_ID(+) =pdi.req_distribution_id;--bug 16871797

Line 10210: po_req_distributions_all prd, --

10206: prd.oke_contract_line_id),
10207: decode(pli.consigned_flag,'Y',null,
10208: prd.oke_contract_deliverable_id)
10209: FROM po_requisition_lines_all prl, --
10210: po_req_distributions_all prd, --
10211: po_lines_interface pli,
10212: po_headers_interface phi
10213: WHERE prd.requisition_line_id = prl.requisition_line_id
10214: AND prl.requisition_line_id = pli.requisition_line_id -- Bug:1563888

Line 15680: l_sob_id PO_REQ_DISTRIBUTIONS_ALL.set_of_books_id%TYPE;

15676: l_return_status VARCHAR2(1);
15677: l_msg_count NUMBER;
15678: l_msg_data VARCHAR2(2000);
15679: l_gl_date_option VARCHAR2(25);
15680: l_sob_id PO_REQ_DISTRIBUTIONS_ALL.set_of_books_id%TYPE;
15681:
15682:
15683: -- Acct. Generator Variables Start
15684: l_dest_charge_success BOOLEAN := TRUE;

Line 15751: FROM po_req_distributions_all prd

15747: d_progress := 30;
15748:
15749: SELECT prd.set_of_books_id
15750: INTO l_sob_id
15751: FROM po_req_distributions_all prd
15752: WHERE prd.requisition_line_id = p_req_line_id
15753: AND ROWNUM = 1;
15754:
15755: d_progress := 40;

Line 15905: , po_req_distributions_all prd

15901: ELSE ROUND((prd.req_line_amount / prl.amount) * poll.amount, p_precision)
15902: END)
15903: ,nvl2(g_calculate_tax_flag, 'CREATE', null) --
15904: FROM po_line_locations_all poll
15905: , po_req_distributions_all prd
15906: , po_requisition_lines_all prl
15907: WHERE poll.po_line_id = p_po_line_id
15908: AND prd.requisition_line_id = p_req_line_id
15909: AND prl.requisition_line_id = prd.requisition_line_id