APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 2463: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

2459: l_progress VARCHAR2(3) := '000';
2460: l_action VARCHAR2(30);
2461: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2462: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2463: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
2464: l_po_return_code VARCHAR2(10);
2465: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%TYPE;
2466:
2467: l_amt_based_line_flag VARCHAR2(1); -- Bug 3480949

Line 2536: , PO_DISTRIBUTIONS_ALL POD

2532: , 'N'
2533: )
2534: INTO l_amt_based_line_flag
2535: FROM PO_LINE_LOCATIONS_ALL PLL
2536: , PO_DISTRIBUTIONS_ALL POD
2537: WHERE POD.po_distribution_id = p_distribution_id
2538: AND PLL.line_location_id = POD.line_location_id
2539: ;
2540:

Line 2592: FROM PO_DISTRIBUTIONS_ALL POD

2588:
2589: -- Get the distribution_type
2590: SELECT POD.distribution_type
2591: INTO l_distribution_type
2592: FROM PO_DISTRIBUTIONS_ALL POD
2593: WHERE POD.po_distribution_id = p_distribution_id;
2594:
2595: l_progress := '070';
2596:

Line 3281: SELECT po_header_id into l_po_document_id FROM po_distributions_all

3277: ELSIF p_doc_level='SHIPMENT' THEN
3278: SELECT po_header_id into l_po_document_id FROM po_line_locations_all
3279: WHERE line_location_id = p_doc_level_id ;
3280: ELSIF p_doc_level='DISTRIBUTION' THEN
3281: SELECT po_header_id into l_po_document_id FROM po_distributions_all
3282: WHERE po_distribution_id = p_doc_level_id ;
3283: END IF;
3284: END IF;
3285:

Line 3291: SELECT po_header_id into l_rel_document_id FROM po_distributions_all

3287: IF p_doc_level='SHIPMENT' THEN
3288: SELECT po_header_id into l_rel_document_id FROM po_line_locations_all
3289: WHERE line_location_id = p_doc_level_id ;
3290: ELSIF p_doc_level='DISTRIBUTION' THEN
3291: SELECT po_header_id into l_rel_document_id FROM po_distributions_all
3292: WHERE po_distribution_id = p_doc_level_id ;
3293: END IF;
3294: END IF;
3295:

Line 4286: -- PO_DISTRIBUTIONS_ALL

4282: -- PO_ENCUMBRANCE_GT
4283: --Locks:
4284: -- PO_HEADERS_ALL
4285: -- PO_RELEASES_ALL
4286: -- PO_DISTRIBUTIONS_ALL
4287: -- PO_REQUISITION_HEADERS_ALL
4288: -- PO_REQ_DISTRIBUTIONS_ALL
4289: --Function:
4290: -- Flattens the PO transaction tables to retrieve all of the

Line 4661: PO_DISTRIBUTIONS_ALL POD

4657: , POD.expenditure_organization_id
4658: , POD.expenditure_item_date
4659: , POH.vendor_id
4660: FROM
4661: PO_DISTRIBUTIONS_ALL POD
4662: , PO_LINE_LOCATIONS_ALL POLL
4663: , PO_LINES_ALL POL
4664: , PO_HEADERS_ALL POH
4665: , PO_SESSION_GT DIST_IDS

Line 4765: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

4761: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_ENC_GT_ACTION_IDS';
4762: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
4763: l_progress VARCHAR2(3) := '000';
4764:
4765: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
4766:
4767: BEGIN
4768:
4769: -- Standard Start of API savepoint

Line 5226: po_distributions_all pod

5222: select nvl(pod.encumbered_flag, 'N')
5223: into l_found
5224: from po_req_distributions_all prd,
5225: po_requisition_lines_all prl,
5226: po_distributions_all pod
5227: where prd.distribution_id = p_req_dist_id
5228: and prl.requisition_line_id = prd.requisition_line_id
5229: and prl.document_type_code = 'BLANKET'
5230: and pod.po_header_id = prl.blanket_po_header_id