APPS.INV_ITEM_CATEGORY_OI dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 213: FROM mtl_system_items_interface

209: cp_organization_id IN NUMBER,
210: cp_xset_id IN NUMBER)
211: IS
212: SELECT inventory_item_id
213: FROM mtl_system_items_interface
214: WHERE item_number = cp_item_number
215: AND organization_id = cp_organization_id
216: AND set_process_id = cp_xset_id
217: AND process_flag IN (1,2,4);

Line 473: SELECT mtl_system_items_interface_s.NEXTVAL

469: -- Also, assign transaction_id, request_id
470:
471: FOR cr IN miss_org_id_csr LOOP
472:
473: SELECT mtl_system_items_interface_s.NEXTVAL
474: INTO l_transaction_id
475: FROM dual;
476:
477: UPDATE mtl_item_categories_interface

Line 479: -- transaction_id = mtl_system_items_interface_s.NEXTVAL

475: FROM dual;
476:
477: UPDATE mtl_item_categories_interface
478: SET
479: -- transaction_id = mtl_system_items_interface_s.NEXTVAL
480: transaction_id = l_transaction_id
481: , request_id = g_request_id
482: , process_flag = 3
483: WHERE CURRENT OF miss_org_id_csr;

Line 550: SELECT mtl_system_items_interface_s.NEXTVAL

546: ELSE
547: l_process_flag := 1;
548: END IF;
549:
550: SELECT mtl_system_items_interface_s.NEXTVAL
551: INTO l_transaction_id
552: FROM dual;
553:
554: l_organization_id := icoi_rec.organization_id;

Line 854: FROM mtl_system_items_interface

850: SELECT item_num_gen_method INTO l_ItemNum_GenMethod
851: FROM mtl_item_Catalog_groups_b
852: WHERE item_catalog_group_id=
853: (SELECT DISTINCT(item_catalog_group_id)
854: FROM mtl_system_items_interface
855: WHERE set_process_id = icoi_rec.set_process_id
856: AND source_system_id = icoi_rec.source_system_id
857: AND source_system_reference = icoi_rec.source_system_reference
858: AND organization_code = icoi_rec.organization_code