APPS.M4R_3B2IN_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 57: Mtl_system_items_kfv msi

53: FROM
54: po_headers_all poh,
55: po_lines_all pol,
56: po_line_locations_all pll,
57: Mtl_system_items_kfv msi
58: WHERE
59: poh.SEGMENT1 = p_po_number AND
60: nvl(msi.concatenated_segments, -99) = nvl(NVL(p_item_num, msi.concatenated_segments), -99) AND
61: nvl(pol.VENDOR_PRODUCT_NUM, -99) = nvl(NVL(p_supplier_item_num, pol.VENDOR_PRODUCT_NUM), -99) AND

Line 76: Mtl_system_items_kfv msi

72: po_headers_all poh,
73: po_lines_all pol,
74: po_line_locations_all pll,
75: po_releases_all prl,
76: Mtl_system_items_kfv msi
77: WHERE
78: poh.SEGMENT1 = p_po_number AND
79: nvl(msi.concatenated_segments, -99) = nvl(NVL(p_item_num, msi.concatenated_segments), -99) AND
80: nvl(pol.VENDOR_PRODUCT_NUM, -99) = nvl(NVL(p_supplier_item_num, pol.VENDOR_PRODUCT_NUM), -99) AND

Line 257: MTL_SYSTEM_ITEMS_KFV MSI

253: FROM
254: po_headers_all poh,
255: po_lines_all pol,
256: po_line_locations_all pll,
257: MTL_SYSTEM_ITEMS_KFV MSI
258: WHERE
259: POH.PO_HEADER_ID = POL.PO_HEADER_ID
260: and POL.PO_LINE_ID = PLL.PO_LINE_ID
261: and pol.item_id = msi.inventory_item_id (+)

Line 292: MTL_SYSTEM_ITEMS_KFV MSI

288: po_headers_all poh,
289: po_lines_all pol,
290: po_line_locations_all pll,
291: po_releases_all prl,
292: MTL_SYSTEM_ITEMS_KFV MSI
293: WHERE
294: POH.PO_HEADER_ID = POL.PO_HEADER_ID
295: and POL.PO_LINE_ID = PLL.PO_LINE_ID
296: and pll.PO_RELEASE_ID = prl.PO_RELEASE_ID