APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 3830: FROM mtl_system_items_kfv

3826: INSERT INTO po_session_gt(key, num1, num2)
3827: SELECT p_key,
3828: p_index_tbl(i),
3829: inventory_item_id
3830: FROM mtl_system_items_kfv
3831: WHERE p_item_tbl(i) IS NOT NULL
3832: AND x_item_id_tbl(i) IS NULL
3833: AND concatenated_segments = p_item_tbl(i)
3834: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;

Line 5245: mtl_system_items item,

5241: item.hazard_class_id,
5242: item.market_price,
5243: decode(item.tracking_quantity_ind, 'PS', uom.unit_of_measure, NULL)
5244: FROM mtl_item_categories item_cat,
5245: mtl_system_items item,
5246: mtl_system_items_tl item_tl,
5247: mtl_units_of_measure uom
5248: WHERE item.inventory_item_id = p_item_id_tbl(i)
5249: AND item_tl.inventory_item_id = item.inventory_item_id

Line 5246: mtl_system_items_tl item_tl,

5242: item.market_price,
5243: decode(item.tracking_quantity_ind, 'PS', uom.unit_of_measure, NULL)
5244: FROM mtl_item_categories item_cat,
5245: mtl_system_items item,
5246: mtl_system_items_tl item_tl,
5247: mtl_units_of_measure uom
5248: WHERE item.inventory_item_id = p_item_id_tbl(i)
5249: AND item_tl.inventory_item_id = item.inventory_item_id
5250: AND item_cat.inventory_item_id = item.inventory_item_id

Line 6749: FROM mtl_system_items items

6745: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
6746: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)
6747: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
6748: AND EXISTS (SELECT 1
6749: FROM mtl_system_items items
6750: WHERE items.inventory_item_id = draft_lines.item_id
6751: AND items.segment1 = x_lines.item_tbl(i)
6752: AND items.organization_id =
6753: NVL(l_def_master_org_id, items.organization_id))

Line 6786: FROM mtl_system_items items

6782: FROM po_lines_draft_all draft_lines
6783: WHERE draft_lines.po_line_id = txn_lines.po_line_id
6784: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
6785: AND EXISTS (SELECT 1
6786: FROM mtl_system_items items
6787: WHERE items.inventory_item_id = txn_lines.item_id
6788: AND items.segment1 = x_lines.item_tbl(i)
6789: AND items.organization_id =
6790: NVL(l_def_master_org_id, items.organization_id))

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

6895:
6896: d_position := 40;
6897:
6898: -- bug4930510
6899: -- Take away the table mtl_system_items from the query since it's
6900: -- never used.
6901: FORALL i IN INDICES OF x_processing_row_tbl
6902: INSERT INTO po_session_gt
6903: (