APPS.PO_AUTOSOURCE_SV dependencies on PO_APPROVED_SUPPLIER_LIST

Line 1535: po_approved_supplier_list pasl,

1531: poh.org_id,
1532: -- Bug 3361128: also select the UOM on the doc
1533: pol.unit_meas_lookup_code
1534: FROM po_asl_documents pad,
1535: po_approved_supplier_list pasl,
1536: po_headers_all poh, --CTO changes FPH
1537: po_lines_all pol --CTO changes FPH
1538: WHERE pasl.asl_id = x_local_asl_id
1539: AND pad.asl_id = pasl.asl_id

Line 1728: po_approved_supplier_list pasl,

1724: poh.global_agreement_flag,
1725: poh.org_id,
1726: NULL unit_meas_lookup_code
1727: FROM po_asl_documents pad,
1728: po_approved_supplier_list pasl,
1729: po_headers_all poh --CTO changes FPH
1730: WHERE pasl.asl_id = x_local_asl_id
1731: AND pad.asl_id = pasl.asl_id
1732: AND pad.using_organization_id = l_using_organization_id --

Line 1931: FROM po_approved_supplier_list

1927: --
1928: BEGIN
1929: SELECT item_id
1930: INTO l_item_id
1931: FROM po_approved_supplier_list
1932: WHERE asl_id = x_local_asl_id;
1933: EXCEPTION
1934: WHEN NO_DATA_FOUND THEN
1935: null;

Line 5927: FROM po_approved_supplier_list pasl,

5923: CURSOR l_get_asl_vendors_csr (p_dest_organization_id IN number) is
5924: SELECT pasl.vendor_id,
5925: pasl.vendor_site_id,
5926: pasl.asl_id
5927: FROM po_approved_supplier_list pasl,
5928: po_asl_status_rules pasr,
5929: po_vendors pov
5930: WHERE pasl.category_id = p_category_id
5931: AND pasl.item_id IS NULL -- as part of Bug# 3379053: For commodity based ASL's,

Line 6137: l_using_organization_id po_approved_supplier_list.using_organization_id%TYPE;

6133: l_base_amount po_lines_all.unit_price%TYPE;
6134: l_currency_code po_headers_all.currency_code%TYPE;
6135: l_price_break_id po_line_locations_all.line_location_id%TYPE;
6136: l_price_diff_src_id po_price_differentials.entity_id%TYPE;
6137: l_using_organization_id po_approved_supplier_list.using_organization_id%TYPE;
6138: l_entity_type po_price_differentials.entity_type%TYPE;
6139: l_vendor_contact_id po_headers_all.vendor_contact_id%TYPE;
6140: l_src_doc_header_id po_headers_all.po_header_id%TYPE;
6141: l_src_doc_line_id po_lines_all.po_line_id%TYPE;

Line 7049: FROM po_approved_supplier_list pasl,

7045: Nvl(paa.enable_vmi_flag,'N')
7046: INTO
7047: x_consignEnabled_flag,
7048: x_VmiEnabled_flag
7049: FROM po_approved_supplier_list pasl,
7050: po_asl_attributes paa,
7051: po_asl_status_rules pasr,
7052: po_vendor_sites_all pvsl,
7053: org_organization_definitions currentorg_ou