APPS.EGO_IMPORT_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 5772: FROM MTL_SYSTEM_ITEMS_B_KFV

5768: Debug_Conc_Log('Processing for SS_ID, SS_REF='||TO_CHAR(i.SOURCE_SYSTEM_ID)||', '||i.SOURCE_SYSTEM_REFERENCE);
5769: IF i.INVENTORY_ITEM_ID IS NULL THEN
5770: BEGIN
5771: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
5772: FROM MTL_SYSTEM_ITEMS_B_KFV
5773: WHERE CONCATENATED_SEGMENTS = i.ITEM_NUMBER
5774: AND ORGANIZATION_ID = i.ORGANIZATION_ID;
5775: EXCEPTION WHEN NO_DATA_FOUND THEN
5776: Debug_Conc_Log('Inventory Item Id is NULL and no Matching Item found for Item Number-'||i.ITEM_NUMBER);

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

6295: FOR UPDATE OF item_number;
6296:
6297: l_err_text VARCHAR2(240) := NULL;
6298: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE := NULL;
6299: l_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE := NULL;
6300: l_ret_code INTEGER;
6301: BEGIN
6302: IF p_is_pdh_batch = FND_API.G_TRUE THEN
6303: FOR item_record IN c_pdh_items_table LOOP

Line 6345: FROM mtl_system_items_b

6341: FOR UPDATE OF transaction_type;
6342:
6343: CURSOR c_item_exists(cp_item_id NUMBER) IS
6344: SELECT 1
6345: FROM mtl_system_items_b
6346: WHERE inventory_item_id = cp_item_id;
6347:
6348: l_item_exist NUMBER(10) := 0;
6349: l_err_text VARCHAR2(200);

Line 6351: l_item_id mtl_system_items_b.inventory_item_id%TYPE;

6347:
6348: l_item_exist NUMBER(10) := 0;
6349: l_err_text VARCHAR2(200);
6350: l_status NUMBER(10):= 0;
6351: l_item_id mtl_system_items_b.inventory_item_id%TYPE;
6352:
6353: BEGIN
6354: FOR item_record IN c_items_table LOOP
6355: l_item_exist := 0;

Line 7259: FROM MTL_SYSTEM_ITEMS_B

7255: )
7256: AND
7257: ( INVENTORY_ITEM_ID IS NULL OR NOT EXISTS
7258: (SELECT 1
7259: FROM MTL_SYSTEM_ITEMS_B
7260: WHERE INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
7261: ) )
7262: AND UPPER( TRANSACTION_TYPE ) = 'UPDATE' #';
7263:

Line 7896: FROM MTL_SYSTEM_ITEMS_B_KFV KFV,

7892: SELECT KFV.CONCATENATED_SEGMENTS ITEM_NUMBER,
7893: MSII.ORGANIZATION_CODE,
7894: MSII.ORGANIZATION_ID,
7895: MSII.TRANSACTION_ID
7896: FROM MTL_SYSTEM_ITEMS_B_KFV KFV,
7897: MTL_SYSTEM_ITEMS_INTERFACE MSII,
7898: MTL_CROSS_REFERENCES MCR
7899: WHERE MSII.SET_PROCESS_ID = p_data_set_id
7900: AND MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'

Line 12113: FROM mtl_system_items_b

12109: FOR UPDATE OF transaction_type;
12110:
12111: CURSOR c_item_exists(cp_item_id NUMBER) IS
12112: SELECT 1
12113: FROM mtl_system_items_b
12114: WHERE inventory_item_id = cp_item_id;
12115:
12116: l_item_exist NUMBER(10) := 0;
12117: l_err_text VARCHAR2(200);

Line 12119: l_item_id mtl_system_items_b.inventory_item_id%TYPE;

12115:
12116: l_item_exist NUMBER(10) := 0;
12117: l_err_text VARCHAR2(200);
12118: l_status NUMBER(10):= 0;
12119: l_item_id mtl_system_items_b.inventory_item_id%TYPE;
12120:
12121: BEGIN
12122:
12123: FOR item_record IN c_items_table LOOP