DBA Data[Home] [Help]

APPS.PO_PDOI_ITEM_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 822: FROM mtl_system_items_vl

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

Line 1016: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

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

Line 1201: FROM mtl_system_items_interface

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

Line 1270: DELETE FROM mtl_system_items_interface

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

Line 1438: FROM mtl_system_items

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