APPS.POS_ASN_XML dependencies on PO_VENDOR_SITES_ALL

Line 549: FROM PO_Vendor_Sites_All

545: WHERE
546: poh.SEGMENT1 = p_po_number AND
547: poh.Vendor_Site_ID IN
548: (SELECT Vendor_Site_ID
549: FROM PO_Vendor_Sites_All
550: WHERE ECE_TP_LOCATION_CODE = p_supplier_code) AND
551: nvl(msi.concatenated_segments, -99) = nvl(NVL(p_item_num, msi.concatenated_segments), -99) AND
552: nvl(pol.VENDOR_PRODUCT_NUM, -99) = nvl(NVL(p_supplier_item_num, pol.VENDOR_PRODUCT_NUM), -99) AND
553: pol.po_header_id = poh.po_header_id AND

Line 574: FROM PO_Vendor_Sites_All

570: WHERE
571: poh.SEGMENT1 = p_po_number AND
572: poh.Vendor_Site_ID IN
573: (SELECT Vendor_Site_ID
574: FROM PO_Vendor_Sites_All
575: WHERE ECE_TP_LOCATION_CODE = p_supplier_code) AND
576: nvl(msi.concatenated_segments, -99) = nvl(NVL(p_item_num, msi.concatenated_segments), -99) AND
577: nvl(pol.VENDOR_PRODUCT_NUM, -99) = nvl(NVL(p_supplier_item_num, pol.VENDOR_PRODUCT_NUM), -99) AND
578: pol.po_header_id = poh.po_header_id AND

Line 630: FROM PO_Vendor_Sites_All

626: WHERE
627: poh.SEGMENT1 = p_po_number AND
628: poh.Vendor_Site_ID IN
629: (SELECT Vendor_Site_ID
630: FROM PO_Vendor_Sites_All
631: WHERE ECE_TP_LOCATION_CODE = p_supplier_code) AND
632: nvl(msi.concatenated_segments, -99) = nvl(NVL(p_item_num, msi.concatenated_segments), -99) AND
633: nvl(pol.VENDOR_PRODUCT_NUM, -99) = nvl(NVL(p_supplier_item_num, pol.VENDOR_PRODUCT_NUM), -99) AND
634: pol.po_header_id = poh.po_header_id AND

Line 655: FROM PO_Vendor_Sites_All

651: WHERE
652: poh.SEGMENT1 = p_po_number AND
653: poh.Vendor_Site_ID IN
654: (SELECT Vendor_Site_ID
655: FROM PO_Vendor_Sites_All
656: WHERE ECE_TP_LOCATION_CODE = p_supplier_code) AND
657: nvl(msi.concatenated_segments, -99) = nvl(NVL(p_item_num, msi.concatenated_segments), -99) AND
658: nvl(pol.VENDOR_PRODUCT_NUM, -99) = nvl(NVL(p_supplier_item_num, pol.VENDOR_PRODUCT_NUM), -99) AND
659: pol.po_header_id = poh.po_header_id AND

Line 813: FROM po_vendor_sites_all

809: vendor_id
810: INTO
811: p_vendor_site_id,
812: p_vendor_id
813: FROM po_vendor_sites_all
814: WHERE ece_tp_location_code = p_supplier_code
815: AND org_id = p_org_id;
816:
817: EXCEPTION