APPS.MSC_IMPORT_ONHAND dependencies on MSC_ITEMS

Line 54: -- Insert any new items into MSC_ITEMS

50: where ATTRIBUTE11 = 'NEW'
51: and ATTRIBUTE8 = 'ONHAND'
52: and ATTRIBUTE7 is null;
53:
54: -- Insert any new items into MSC_ITEMS
55: insert into MSC_ITEMS( INVENTORY_ITEM_ID,
56: ITEM_NAME,
57: DESCRIPTION,
58: LAST_UPDATE_DATE,

Line 55: insert into MSC_ITEMS( INVENTORY_ITEM_ID,

51: and ATTRIBUTE8 = 'ONHAND'
52: and ATTRIBUTE7 is null;
53:
54: -- Insert any new items into MSC_ITEMS
55: insert into MSC_ITEMS( INVENTORY_ITEM_ID,
56: ITEM_NAME,
57: DESCRIPTION,
58: LAST_UPDATE_DATE,
59: LAST_UPDATED_BY,

Line 62: select MSC_ITEMS_S.NEXTVAL,

58: LAST_UPDATE_DATE,
59: LAST_UPDATED_BY,
60: CREATION_DATE,
61: CREATED_BY )
62: select MSC_ITEMS_S.NEXTVAL,
63: MSD1.ATTRIBUTE3,
64: MSD1.ATTRIBUTE13,
65: SYSDATE,
66: l_user_id,

Line 74: from msc_items item

70: from MSC_ST_DEMANDS MSD
71: where MSD.ATTRIBUTE11 = 'NEW'
72: and MSD.ATTRIBUTE8 = 'ONHAND'
73: and not exists (select 'exists'
74: from msc_items item
75: where item.item_name = MSD.ATTRIBUTE3)) MSD1;
76:
77: -- Do monster insert into msc_system_items for Buyer
78:

Line 121: msc_items mi

117: hp.party_id,
118: mi.inventory_item_id
119: from MSC_ST_DEMANDS MSD,
120: hz_parties hp,
121: msc_items mi
122: where mi.item_name = MSD.ATTRIBUTE3
123: and MSD.ATTRIBUTE1 = hp.party_name
124: and hp.party_type = 'ORGANIZATION'
125: and MSD.ATTRIBUTE11 = 'NEW'

Line 168: msc_items mi

164: SYSDATE,
165: l_user_id
166: from hz_parties hz,
167: MSC_ST_DEMANDS MSD,
168: msc_items mi
169: where MSD.ATTRIBUTE3 = mi.item_name
170: and MSD.ATTRIBUTE11 = 'NEW'
171: and MSD.ATTRIBUTE8 = 'ONHAND'
172: and hz.party_name = MSD.ATTRIBUTE1