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 1487: from MSC_ITEMS mi

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

Line 1506: MSC_ITEMS mi

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

Line 1637: INSERT INTO MSC_ITEMS

1633: FOR c_rec IN c4 LOOP
1634:
1635: BEGIN
1636:
1637: INSERT INTO MSC_ITEMS
1638: ( ITEM_NAME,
1639: INVENTORY_ITEM_ID,
1640: LAST_UPDATE_DATE,
1641: LAST_UPDATED_BY,

Line 1646: MSC_Items_S.NEXTVAL,

1642: CREATION_DATE,
1643: CREATED_BY)
1644: VALUES
1645: ( c_rec.Item_Name,
1646: MSC_Items_S.NEXTVAL,
1647: MSC_CL_COLLECTION.v_current_date,
1648: MSC_CL_COLLECTION.v_current_user,
1649: MSC_CL_COLLECTION.v_current_date,
1650: MSC_CL_COLLECTION.v_current_user);

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

1659:
1660: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1661: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1662: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1663: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEMS');
1664: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1665:
1666: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1667: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

Line 4573: UPDATE MSC_ITEMS

4569: END IF;
4570: END IF;
4571: IF ( lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR
4572: lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
4573: UPDATE MSC_ITEMS
4574: SET description= lb_DESCRIPTION(j)
4575: WHERE inventory_item_id = lb_INVENTORY_ITEM_ID(j);
4576: END IF;
4577: c_count:= c_count+1;