DBA Data[Home] [Help]

APPS.PO_PDOI_ITEM_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE

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;