APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 4752: FROM mtl_system_items_kfv

4748: INSERT INTO po_session_gt(key, num1, num2)
4749: SELECT p_key,
4750: p_index_tbl(i),
4751: inventory_item_id
4752: FROM mtl_system_items_kfv
4753: WHERE p_item_tbl(i) IS NOT NULL
4754: AND x_item_id_tbl(i) IS NULL
4755: AND concatenated_segments = p_item_tbl(i)
4756: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;

Line 6167: mtl_system_items item,

6163: item.hazard_class_id,
6164: item.market_price,
6165: decode(item.tracking_quantity_ind, 'PS', uom.unit_of_measure, NULL)
6166: FROM mtl_item_categories item_cat,
6167: mtl_system_items item,
6168: mtl_system_items_tl item_tl,
6169: mtl_units_of_measure uom
6170: WHERE item.inventory_item_id = p_item_id_tbl(i)
6171: AND item_tl.inventory_item_id = item.inventory_item_id

Line 6168: mtl_system_items_tl item_tl,

6164: item.market_price,
6165: decode(item.tracking_quantity_ind, 'PS', uom.unit_of_measure, NULL)
6166: FROM mtl_item_categories item_cat,
6167: mtl_system_items item,
6168: mtl_system_items_tl item_tl,
6169: mtl_units_of_measure uom
6170: WHERE item.inventory_item_id = p_item_id_tbl(i)
6171: AND item_tl.inventory_item_id = item.inventory_item_id
6172: AND item_cat.inventory_item_id = item.inventory_item_id

Line 7716: FROM mtl_system_items items

7712: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7713: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)
7714: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
7715: AND EXISTS (SELECT 1
7716: FROM mtl_system_items items
7717: WHERE items.inventory_item_id = draft_lines.item_id
7718: AND items.segment1 = x_lines.item_tbl(i)
7719: AND items.organization_id =
7720: NVL(l_def_master_org_id, items.organization_id))

Line 7753: FROM mtl_system_items items

7749: FROM po_lines_draft_all draft_lines
7750: WHERE draft_lines.po_line_id = txn_lines.po_line_id
7751: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
7752: AND EXISTS (SELECT 1
7753: FROM mtl_system_items items
7754: WHERE items.inventory_item_id = txn_lines.item_id
7755: AND items.segment1 = x_lines.item_tbl(i)
7756: AND items.organization_id =
7757: NVL(l_def_master_org_id, items.organization_id))

Line 7866: -- Take away the table mtl_system_items from the query since it's

7862:
7863: d_position := 40;
7864:
7865: -- bug4930510
7866: -- Take away the table mtl_system_items from the query since it's
7867: -- never used.
7868: FORALL i IN INDICES OF x_processing_row_tbl
7869: INSERT INTO po_session_gt
7870: (