APPS.INV_ITEM_ORG_ASSIGN_CP dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 1027: FROM mtl_system_items_interface

1023: -- from the interface tables
1024: -- Otherwise, that record exists in the interface tables
1025: SELECT COUNT(*)
1026: INTO l_error_count
1027: FROM mtl_system_items_interface
1028: WHERE request_id = FND_GLOBAL.conc_request_id
1029: /*AND process_flag = 4; Bug 5962957 Changing this to 1 since the records are passed in as process_flag 1*/
1030: AND process_flag = 1;
1031:

Line 1369: mtl_system_items_interface

1365: , organization_id
1366: , transaction_id
1367: , set_process_id
1368: FROM
1369: mtl_system_items_interface
1370: WHERE set_process_id = c_set_process_id
1371: AND inventory_item_id = c_inventory_item_id
1372: AND organization_id = c_organization_id
1373: FOR UPDATE;

Line 1768: INSERT INTO mtl_system_items_interface

1764:
1765:
1766:
1767: FORALL l_Idx IN l_min_index..l_max_index
1768: INSERT INTO mtl_system_items_interface
1769: ( process_flag
1770: , set_process_id
1771: , transaction_type
1772: , inventory_item_id

Line 1932: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1928: ,l_rev_label
1929: ,l_rev_label
1930: ,SYSDATE
1931: ,SYSDATE
1932: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1933: ,/*4 Bug 5962957 here the validation should happen so changing it to 1*/ 1
1934: ,'CREATE'
1935: ,l_set_process_id
1936: ,SYSDATE