DBA Data[Home] [Help]

APPS.PO_PDOI_ITEM_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE

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;