APPS.MSC_IMPORT_FORECAST dependencies on MSC_ITEMS

Line 43: -- Insert any new items into MSC_ITEMS

39: where ATTRIBUTE11 = 'NEW'
40: and ATTRIBUTE8 = 'FORECAST'
41: and ATTRIBUTE7 < 0 ;
42:
43: -- Insert any new items into MSC_ITEMS
44: insert into MSC_ITEMS( INVENTORY_ITEM_ID,
45: ITEM_NAME,
46: LAST_UPDATE_DATE,
47: LAST_UPDATED_BY,

Line 44: insert into MSC_ITEMS( INVENTORY_ITEM_ID,

40: and ATTRIBUTE8 = 'FORECAST'
41: and ATTRIBUTE7 < 0 ;
42:
43: -- Insert any new items into MSC_ITEMS
44: insert into MSC_ITEMS( INVENTORY_ITEM_ID,
45: ITEM_NAME,
46: LAST_UPDATE_DATE,
47: LAST_UPDATED_BY,
48: CREATION_DATE,

Line 50: select MSC_ITEMS_S.NEXTVAL,

46: LAST_UPDATE_DATE,
47: LAST_UPDATED_BY,
48: CREATION_DATE,
49: CREATED_BY )
50: select MSC_ITEMS_S.NEXTVAL,
51: MSD1.ATTRIBUTE3,
52: SYSDATE,
53: l_user_id,
54: SYSDATE,

Line 61: from msc_items item

57: from msc_st_demands MSD
58: where MSD.ATTRIBUTE11 = 'NEW'
59: and MSD.ATTRIBUTE8 = 'FORECAST'
60: and not exists (select 'exists'
61: from msc_items item
62: where item.item_name = MSD.ATTRIBUTE3)) MSD1;
63:
64: -- Do monster insert into msc_system_items for Seller
65:

Line 108: msc_items mi

104: hp.party_id,
105: mi.inventory_item_id
106: from msc_st_demands MSD,
107: hz_parties hp,
108: msc_items mi
109: where mi.item_name = MSD.ATTRIBUTE3
110: and MSD.ATTRIBUTE1 = hp.party_name
111: and hp.party_type = 'ORGANIZATION'
112: and MSD.ATTRIBUTE11 = 'NEW'

Line 168: msc_items mi

164: hp.party_id,
165: mi.inventory_item_id
166: from msc_st_demands MSD,
167: hz_parties hp,
168: msc_items mi
169: where mi.item_name = MSD.ATTRIBUTE3
170: and MSD.ATTRIBUTE2 = hp.party_name
171: and hp.party_type = 'ORGANIZATION'
172: and MSD.ATTRIBUTE11 = 'NEW'

Line 217: msc_items mi,

213: SYSDATE,
214: '-1'
215: from hz_parties seller,
216: hz_parties buyer,
217: msc_items mi,
218: msc_st_demands MSD
219: where seller.party_name = msd.attribute1
220: and seller.party_type = 'ORGANIZATION'
221: and buyer.party_name = msd.attribute2