APPS.POS_ASN_XML dependencies on PO_VENDOR_SITES_ALL

Line 528: FROM PO_Vendor_Sites_All

524: WHERE
525: poh.SEGMENT1 = p_po_number AND
526: poh.Vendor_Site_ID IN
527: (SELECT Vendor_Site_ID
528: FROM PO_Vendor_Sites_All
529: WHERE ECE_TP_LOCATION_CODE = p_supplier_code) AND
530: nvl(msi.concatenated_segments, -99) = nvl(NVL(p_item_num, msi.concatenated_segments), -99) AND
531: nvl(pol.VENDOR_PRODUCT_NUM, -99) = nvl(NVL(p_supplier_item_num, pol.VENDOR_PRODUCT_NUM), -99) AND
532: pol.po_header_id = poh.po_header_id AND

Line 553: FROM PO_Vendor_Sites_All

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

Line 609: FROM PO_Vendor_Sites_All

605: WHERE
606: poh.SEGMENT1 = p_po_number AND
607: poh.Vendor_Site_ID IN
608: (SELECT Vendor_Site_ID
609: FROM PO_Vendor_Sites_All
610: WHERE ECE_TP_LOCATION_CODE = p_supplier_code) AND
611: nvl(msi.concatenated_segments, -99) = nvl(NVL(p_item_num, msi.concatenated_segments), -99) AND
612: nvl(pol.VENDOR_PRODUCT_NUM, -99) = nvl(NVL(p_supplier_item_num, pol.VENDOR_PRODUCT_NUM), -99) AND
613: pol.po_header_id = poh.po_header_id AND

Line 634: FROM PO_Vendor_Sites_All

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

Line 792: FROM po_vendor_sites_all

788: vendor_id
789: INTO
790: p_vendor_site_id,
791: p_vendor_id
792: FROM po_vendor_sites_all
793: WHERE ece_tp_location_code = p_supplier_code
794: AND org_id = p_org_id;
795:
796: EXCEPTION