APPS.EGO_IMPORT_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 5838: FROM MTL_SYSTEM_ITEMS_B_KFV

5834: Debug_Conc_Log('Processing for SS_ID, SS_REF='||TO_CHAR(i.SOURCE_SYSTEM_ID)||', '||i.SOURCE_SYSTEM_REFERENCE);
5835: IF i.INVENTORY_ITEM_ID IS NULL THEN
5836: BEGIN
5837: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
5838: FROM MTL_SYSTEM_ITEMS_B_KFV
5839: WHERE CONCATENATED_SEGMENTS = i.ITEM_NUMBER
5840: AND ORGANIZATION_ID = i.ORGANIZATION_ID;
5841: EXCEPTION WHEN NO_DATA_FOUND THEN
5842: Debug_Conc_Log('Inventory Item Id is NULL and no Matching Item found for Item Number-'||i.ITEM_NUMBER);

Line 6381: l_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE := NULL;

6377: FOR UPDATE OF item_number;
6378:
6379: l_err_text VARCHAR2(240) := NULL;
6380: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE := NULL;
6381: l_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE := NULL;
6382: l_ret_code INTEGER;
6383: BEGIN
6384: IF p_is_pdh_batch = FND_API.G_TRUE THEN
6385: FOR item_record IN c_pdh_items_table LOOP

Line 6427: FROM mtl_system_items_b

6423: FOR UPDATE OF transaction_type;
6424:
6425: CURSOR c_item_exists(cp_item_id NUMBER) IS
6426: SELECT 1
6427: FROM mtl_system_items_b
6428: WHERE inventory_item_id = cp_item_id;
6429:
6430: l_item_exist NUMBER(10) := 0;
6431: l_err_text VARCHAR2(200);

Line 6433: l_item_id mtl_system_items_b.inventory_item_id%TYPE;

6429:
6430: l_item_exist NUMBER(10) := 0;
6431: l_err_text VARCHAR2(200);
6432: l_status NUMBER(10):= 0;
6433: l_item_id mtl_system_items_b.inventory_item_id%TYPE;
6434:
6435: BEGIN
6436: FOR item_record IN c_items_table LOOP
6437: l_item_exist := 0;

Line 7353: FROM MTL_SYSTEM_ITEMS_B

7349: )
7350: AND
7351: ( INVENTORY_ITEM_ID IS NULL OR NOT EXISTS
7352: (SELECT 1
7353: FROM MTL_SYSTEM_ITEMS_B
7354: WHERE INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
7355: ) )
7356: AND UPPER( TRANSACTION_TYPE ) = 'UPDATE' #';
7357:

Line 7998: FROM MTL_SYSTEM_ITEMS_B_KFV KFV,

7994: SELECT KFV.CONCATENATED_SEGMENTS ITEM_NUMBER,
7995: MSII.ORGANIZATION_CODE,
7996: MSII.ORGANIZATION_ID,
7997: MSII.TRANSACTION_ID
7998: FROM MTL_SYSTEM_ITEMS_B_KFV KFV,
7999: MTL_SYSTEM_ITEMS_INTERFACE MSII,
8000: MTL_CROSS_REFERENCES MCR
8001: WHERE MSII.SET_PROCESS_ID = p_data_set_id
8002: AND MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'

Line 12233: FROM mtl_system_items_b

12229: FOR UPDATE OF transaction_type;
12230:
12231: CURSOR c_item_exists(cp_item_id NUMBER) IS
12232: SELECT 1
12233: FROM mtl_system_items_b
12234: WHERE inventory_item_id = cp_item_id;
12235:
12236: l_item_exist NUMBER(10) := 0;
12237: l_err_text VARCHAR2(200);

Line 12239: l_item_id mtl_system_items_b.inventory_item_id%TYPE;

12235:
12236: l_item_exist NUMBER(10) := 0;
12237: l_err_text VARCHAR2(200);
12238: l_status NUMBER(10):= 0;
12239: l_item_id mtl_system_items_b.inventory_item_id%TYPE;
12240:
12241: BEGIN
12242:
12243: FOR item_record IN c_items_table LOOP