[Home] [Help]
1523: poh.org_id,
1524: -- Bug 3361128: also select the UOM on the doc
1525: pol.unit_meas_lookup_code
1526: FROM po_asl_documents pad,
1527: po_approved_supplier_list pasl,
1528: po_headers_all poh, --CTO changes FPH
1529: po_lines_all pol --CTO changes FPH
1530: WHERE pasl.asl_id = x_local_asl_id
1531: AND pad.asl_id = pasl.asl_id
1711: poh.global_agreement_flag,
1712: poh.org_id,
1713: NULL unit_meas_lookup_code
1714: FROM po_asl_documents pad,
1715: po_approved_supplier_list pasl,
1716: po_headers_all poh --CTO changes FPH
1717: WHERE pasl.asl_id = x_local_asl_id
1718: AND pad.asl_id = pasl.asl_id
1719: AND pad.using_organization_id = l_using_organization_id --
1914: --
1915: BEGIN
1916: SELECT item_id
1917: INTO l_item_id
1918: FROM po_approved_supplier_list
1919: WHERE asl_id = x_local_asl_id;
1920: EXCEPTION
1921: WHEN NO_DATA_FOUND THEN
1922: null;
5846: CURSOR l_get_asl_vendors_csr (p_dest_organization_id IN number) is
5847: SELECT pasl.vendor_id,
5848: pasl.vendor_site_id,
5849: pasl.asl_id
5850: FROM po_approved_supplier_list pasl,
5851: po_asl_status_rules pasr,
5852: po_vendors pov
5853: WHERE pasl.category_id = p_category_id
5854: AND pasl.item_id IS NULL -- as part of Bug# 3379053: For commodity based ASL's,
6056: l_base_amount po_lines_all.unit_price%TYPE;
6057: l_currency_code po_headers_all.currency_code%TYPE;
6058: l_price_break_id po_line_locations_all.line_location_id%TYPE;
6059: l_price_diff_src_id po_price_differentials.entity_id%TYPE;
6060: l_using_organization_id po_approved_supplier_list.using_organization_id%TYPE;
6061: l_entity_type po_price_differentials.entity_type%TYPE;
6062: l_vendor_contact_id po_headers_all.vendor_contact_id%TYPE;
6063: l_src_doc_header_id po_headers_all.po_header_id%TYPE;
6064: l_src_doc_line_id po_lines_all.po_line_id%TYPE;