APPS.PO_INTERFACE_S dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 3546: FROM PO_REQ_DISTRIBUTIONS_ALL --

3542:
3543: BEGIN
3544: SELECT MIN(DISTRIBUTION_ID)
3545: INTO x_req_dist_id
3546: FROM PO_REQ_DISTRIBUTIONS_ALL --
3547: WHERE REQUISITION_LINE_ID = interface.requisition_line_id
3548: AND PROJECT_ID IS NOT NULL
3549: AND TASK_ID IS NOT NULL;
3550: EXCEPTION

Line 3571: FROM PO_REQ_DISTRIBUTIONS_ALL --

3567: IF x_req_dist_id IS NULL THEN
3568: BEGIN
3569: SELECT MIN(DISTRIBUTION_ID)
3570: INTO x_req_dist_id
3571: FROM PO_REQ_DISTRIBUTIONS_ALL --
3572: WHERE REQUISITION_LINE_ID = interface.requisition_line_id
3573: AND PROJECT_ID IS NOT NULL;
3574: EXCEPTION
3575: WHEN OTHERS THEN

Line 3592: FROM PO_REQ_DISTRIBUTIONS_ALL --

3588: SELECT project_id
3589: ,task_id
3590: INTO x_project_id
3591: , x_task_id
3592: FROM PO_REQ_DISTRIBUTIONS_ALL --
3593: WHERE DISTRIBUTION_ID = x_req_dist_id;
3594: EXCEPTION
3595: WHEN NO_DATA_FOUND THEN
3596: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 9580: po_req_distributions_all prd, --

9576: prd.oke_contract_line_id),
9577: decode(pli.consigned_flag,'Y',null,
9578: prd.oke_contract_deliverable_id)
9579: FROM po_requisition_lines_all prl, --
9580: po_req_distributions_all prd, --
9581: po_lines_interface pli,
9582: po_headers_interface phi
9583: WHERE prd.requisition_line_id = prl.requisition_line_id
9584: AND prl.requisition_line_id = pli.requisition_line_id -- Bug:1563888

Line 14771: l_sob_id PO_REQ_DISTRIBUTIONS_ALL.set_of_books_id%TYPE;

14767: l_return_status VARCHAR2(1);
14768: l_msg_count NUMBER;
14769: l_msg_data VARCHAR2(2000);
14770: l_gl_date_option VARCHAR2(25);
14771: l_sob_id PO_REQ_DISTRIBUTIONS_ALL.set_of_books_id%TYPE;
14772:
14773:
14774: -- Acct. Generator Variables Start
14775: l_dest_charge_success BOOLEAN := TRUE;

Line 14842: FROM po_req_distributions_all prd

14838: d_progress := 30;
14839:
14840: SELECT prd.set_of_books_id
14841: INTO l_sob_id
14842: FROM po_req_distributions_all prd
14843: WHERE prd.requisition_line_id = p_req_line_id
14844: AND ROWNUM = 1;
14845:
14846: d_progress := 40;

Line 14996: , po_req_distributions_all prd

14992: ELSE ROUND((prd.req_line_amount / prl.amount) * poll.amount, p_precision)
14993: END)
14994: ,nvl2(g_calculate_tax_flag, 'CREATE', null) --
14995: FROM po_line_locations_all poll
14996: , po_req_distributions_all prd
14997: , po_requisition_lines_all prl
14998: WHERE poll.po_line_id = p_po_line_id
14999: AND prd.requisition_line_id = p_req_line_id
15000: AND prl.requisition_line_id = prd.requisition_line_id