DBA Data[Home] [Help]

APPS.POS_ASN_XML dependencies on MTL_SYSTEM_ITEMS_KFV

Line 523: Mtl_system_items_kfv msi

519: FROM
520: po_headers_all poh,
521: po_lines_all pol,
522: po_line_locations_all pll,
523: Mtl_system_items_kfv msi
524: WHERE
525: poh.SEGMENT1 = p_po_number AND
526: poh.Vendor_Site_ID IN
527: (SELECT Vendor_Site_ID

Line 548: Mtl_system_items_kfv msi

544: po_headers_all poh,
545: po_lines_all pol,
546: po_line_locations_all pll,
547: po_releases_all prl,
548: Mtl_system_items_kfv msi
549: WHERE
550: poh.SEGMENT1 = p_po_number AND
551: poh.Vendor_Site_ID IN
552: (SELECT Vendor_Site_ID

Line 604: Mtl_system_items_kfv msi

600: FROM
601: po_headers_all poh,
602: po_lines_all pol,
603: po_line_locations_all pll,
604: Mtl_system_items_kfv msi
605: WHERE
606: poh.SEGMENT1 = p_po_number AND
607: poh.Vendor_Site_ID IN
608: (SELECT Vendor_Site_ID

Line 629: Mtl_system_items_kfv msi

625: po_headers_all poh,
626: po_lines_all pol,
627: po_line_locations_all pll,
628: po_releases_all prl,
629: Mtl_system_items_kfv msi
630: WHERE
631: poh.SEGMENT1 = p_po_number AND
632: poh.Vendor_Site_ID IN
633: (SELECT Vendor_Site_ID

Line 1009: MTL_SYSTEM_ITEMS_KFV MSI

1005: FROM
1006: po_headers_all poh,
1007: po_lines_all pol,
1008: po_line_locations_all pll,
1009: MTL_SYSTEM_ITEMS_KFV MSI
1010: WHERE
1011: POH.PO_HEADER_ID = POL.PO_HEADER_ID
1012: and POL.PO_LINE_ID = PLL.PO_LINE_ID
1013: and pol.item_id = msi.inventory_item_id (+)

Line 1031: MTL_SYSTEM_ITEMS_KFV MSI

1027: po_headers_all poh,
1028: po_lines_all pol,
1029: po_line_locations_all pll,
1030: po_releases_all prl,
1031: MTL_SYSTEM_ITEMS_KFV MSI
1032: WHERE
1033: POH.PO_HEADER_ID = POL.PO_HEADER_ID
1034: and POL.PO_LINE_ID = PLL.PO_LINE_ID
1035: and pll.PO_RELEASE_ID = prl.PO_RELEASE_ID

Line 1071: MTL_SYSTEM_ITEMS_KFV MSI

1067: FROM
1068: po_headers_all poh,
1069: po_lines_all pol,
1070: po_line_locations_all pll,
1071: MTL_SYSTEM_ITEMS_KFV MSI
1072: WHERE
1073: POH.PO_HEADER_ID = POL.PO_HEADER_ID
1074: and POL.PO_LINE_ID = PLL.PO_LINE_ID
1075: and pol.item_id = msi.inventory_item_id (+)

Line 1109: MTL_SYSTEM_ITEMS_KFV MSI

1105: po_headers_all poh,
1106: po_lines_all pol,
1107: po_line_locations_all pll,
1108: po_releases_all prl,
1109: MTL_SYSTEM_ITEMS_KFV MSI
1110: WHERE
1111: POH.PO_HEADER_ID = POL.PO_HEADER_ID
1112: and POL.PO_LINE_ID = PLL.PO_LINE_ID
1113: and pll.PO_RELEASE_ID = prl.PO_RELEASE_ID