APPS.POS_ASN_XML dependencies on MTL_SYSTEM_ITEMS_KFV

Line 544: Mtl_system_items_kfv msi

540: FROM
541: po_headers_all poh,
542: po_lines_all pol,
543: po_line_locations_all pll,
544: Mtl_system_items_kfv msi
545: WHERE
546: poh.SEGMENT1 = p_po_number AND
547: poh.Vendor_Site_ID IN
548: (SELECT Vendor_Site_ID

Line 569: Mtl_system_items_kfv msi

565: po_headers_all poh,
566: po_lines_all pol,
567: po_line_locations_all pll,
568: po_releases_all prl,
569: Mtl_system_items_kfv msi
570: WHERE
571: poh.SEGMENT1 = p_po_number AND
572: poh.Vendor_Site_ID IN
573: (SELECT Vendor_Site_ID

Line 625: Mtl_system_items_kfv msi

621: FROM
622: po_headers_all poh,
623: po_lines_all pol,
624: po_line_locations_all pll,
625: Mtl_system_items_kfv msi
626: WHERE
627: poh.SEGMENT1 = p_po_number AND
628: poh.Vendor_Site_ID IN
629: (SELECT Vendor_Site_ID

Line 650: Mtl_system_items_kfv msi

646: po_headers_all poh,
647: po_lines_all pol,
648: po_line_locations_all pll,
649: po_releases_all prl,
650: Mtl_system_items_kfv msi
651: WHERE
652: poh.SEGMENT1 = p_po_number AND
653: poh.Vendor_Site_ID IN
654: (SELECT Vendor_Site_ID

Line 1040: MTL_SYSTEM_ITEMS_KFV MSI

1036: FROM
1037: po_headers_all poh,
1038: po_lines_all pol,
1039: po_line_locations_all pll,
1040: MTL_SYSTEM_ITEMS_KFV MSI
1041: WHERE
1042: POH.PO_HEADER_ID = POL.PO_HEADER_ID
1043: and POL.PO_LINE_ID = PLL.PO_LINE_ID
1044: and pol.item_id = msi.inventory_item_id (+)

Line 1062: MTL_SYSTEM_ITEMS_KFV MSI

1058: po_headers_all poh,
1059: po_lines_all pol,
1060: po_line_locations_all pll,
1061: po_releases_all prl,
1062: MTL_SYSTEM_ITEMS_KFV MSI
1063: WHERE
1064: POH.PO_HEADER_ID = POL.PO_HEADER_ID
1065: and POL.PO_LINE_ID = PLL.PO_LINE_ID
1066: and pll.PO_RELEASE_ID = prl.PO_RELEASE_ID

Line 1102: MTL_SYSTEM_ITEMS_KFV MSI

1098: FROM
1099: po_headers_all poh,
1100: po_lines_all pol,
1101: po_line_locations_all pll,
1102: MTL_SYSTEM_ITEMS_KFV MSI
1103: WHERE
1104: POH.PO_HEADER_ID = POL.PO_HEADER_ID
1105: and POL.PO_LINE_ID = PLL.PO_LINE_ID
1106: and pol.item_id = msi.inventory_item_id (+)

Line 1140: MTL_SYSTEM_ITEMS_KFV MSI

1136: po_headers_all poh,
1137: po_lines_all pol,
1138: po_line_locations_all pll,
1139: po_releases_all prl,
1140: MTL_SYSTEM_ITEMS_KFV MSI
1141: WHERE
1142: POH.PO_HEADER_ID = POL.PO_HEADER_ID
1143: and POL.PO_LINE_ID = PLL.PO_LINE_ID
1144: and pll.PO_RELEASE_ID = prl.PO_RELEASE_ID