APPS.PO_PDOI_ITEM_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 823: FROM mtl_system_items_vl

819: l_key,
820: x_proc_row_in_round_tbl(i),
821: organization_id,
822: inventory_item_id
823: FROM mtl_system_items_vl
824: WHERE organization_id IN
825: (PO_PDOI_PARAMS.g_sys.def_inv_org_id,
826: PO_PDOI_PARAMS.g_sys.master_inv_org_id,
827: x_items.ship_to_org_id_tbl(i)

Line 1017: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

1013:
1014: d_position := 10;
1015:
1016: FORALL i IN INDICES OF p_index_tbl
1017: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
1018: (
1019: process_flag,
1020: set_process_id,
1021: transaction_type,

Line 1202: FROM mtl_system_items_interface

1198: transaction_id,
1199: inventory_item_id,
1200: organization_id,
1201: revision
1202: FROM mtl_system_items_interface
1203: WHERE set_process_id = l_set_process_id_tbl(i);
1204:
1205: d_position := 40;
1206:

Line 1271: DELETE FROM mtl_system_items_interface

1267: d_position := 60;
1268:
1269: -- delete rows from item interface tables
1270: FORALL i IN 1..l_index_tbl.COUNT
1271: DELETE FROM mtl_system_items_interface
1272: WHERE transaction_id = l_transaction_id_tbl(i)
1273: AND set_process_id = l_set_process_id_tbl(i);
1274:
1275: d_position := 70;

Line 1439: FROM mtl_system_items

1435: SELECT l_key,
1436: l_update_index_tbl(i),
1437: description,
1438: list_price_per_unit
1439: FROM mtl_system_items
1440: WHERE inventory_item_id = x_items.ln_item_id_tbl(i)
1441: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;
1442:
1443: d_position := 10;