APPS.MSC_CL_ITEM_ODS_LOAD dependencies on MSC_ITEMS

Line 235: FROM MSC_ITEMS

231: RETURN VARCHAR2
232: IS
233: CURSOR c_item( cp_item_id IN NUMBER) IS
234: SELECT ITEM_NAME
235: FROM MSC_ITEMS
236: WHERE INVENTORY_ITEM_ID= cp_item_id;
237:
238: lv_item_name VARCHAR2(250):= NULL;
239: BEGIN

Line 1490: from MSC_ITEMS mi

1486: Cursor c4 IS
1487: SELECT distinct msi.Item_Name
1488: FROM MSC_ST_SYSTEM_ITEMS msi
1489: WHERE NOT EXISTS ( select 1
1490: from MSC_ITEMS mi
1491: where mi.Item_Name= msi.Item_Name)
1492: AND msi.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1493: ORDER BY msi.Item_Name; -- using ORDER BY to avoid dead lock
1494:

Line 1509: MSC_ITEMS mi

1505: CURSOR c11 IS
1506: SELECT distinct
1507: msi.SR_INVENTORY_ITEM_ID, msi.SR_INSTANCE_ID, mi.INVENTORY_ITEM_ID
1508: FROM MSC_ST_SYSTEM_ITEMS msi,
1509: MSC_ITEMS mi
1510: WHERE NOT EXISTS( select 1
1511: from MSC_ITEM_ID_LID miil
1512: where msi.SR_INVENTORY_ITEM_ID=
1513: miil.SR_INVENTORY_ITEM_ID

Line 1641: INSERT INTO MSC_ITEMS

1637: FOR c_rec IN c4 LOOP
1638:
1639: BEGIN
1640:
1641: INSERT INTO MSC_ITEMS
1642: ( ITEM_NAME,
1643: INVENTORY_ITEM_ID,
1644: LAST_UPDATE_DATE,
1645: LAST_UPDATED_BY,

Line 1650: MSC_Items_S.NEXTVAL,

1646: CREATION_DATE,
1647: CREATED_BY)
1648: VALUES
1649: ( c_rec.Item_Name,
1650: MSC_Items_S.NEXTVAL,
1651: MSC_CL_COLLECTION.v_current_date,
1652: MSC_CL_COLLECTION.v_current_user,
1653: MSC_CL_COLLECTION.v_current_date,
1654: MSC_CL_COLLECTION.v_current_user);

Line 1667: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEMS');

1663:
1664: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1665: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1666: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1667: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEMS');
1668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1669:
1670: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1671: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

Line 4603: UPDATE MSC_ITEMS

4599: END IF;
4600: END IF;
4601: IF ( lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR
4602: lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
4603: UPDATE MSC_ITEMS
4604: SET description= lb_DESCRIPTION(j)
4605: WHERE inventory_item_id = lb_INVENTORY_ITEM_ID(j);
4606: END IF;
4607: c_count:= c_count+1;