APPS.MSC_IMPORT_FORECAST dependencies on MSC_SYSTEM_ITEMS

Line 64: -- Do monster insert into msc_system_items for Seller

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:
66: insert into MSC_SYSTEM_ITEMS(
67: PLAN_ID, ORGANIZATION_ID,
68: INVENTORY_ITEM_ID, SR_INSTANCE_ID,

Line 66: insert into MSC_SYSTEM_ITEMS(

62: where item.item_name = MSD.ATTRIBUTE3)) MSD1;
63:
64: -- Do monster insert into msc_system_items for Seller
65:
66: insert into MSC_SYSTEM_ITEMS(
67: PLAN_ID, ORGANIZATION_ID,
68: INVENTORY_ITEM_ID, SR_INSTANCE_ID,
69: SR_INVENTORY_ITEM_ID,ITEM_NAME,
70: LOT_CONTROL_CODE, ROUNDING_CONTROL_TYPE,

Line 118: msc_system_items msi

114: and not exists
115: ( select 'exists'
116: from msc_st_demands,
117: hz_parties,
118: msc_system_items msi
119: where msi.organization_id = hp.party_id
120: and hp.party_name = MSD.ATTRIBUTE1
121: and hp.party_type = 'ORGANIZATION'
122: and msi.item_name = MSD.ATTRIBUTE3)) MSD1;

Line 124: -- Do monster insert into msc_system_items for Buyer

120: and hp.party_name = MSD.ATTRIBUTE1
121: and hp.party_type = 'ORGANIZATION'
122: and msi.item_name = MSD.ATTRIBUTE3)) MSD1;
123:
124: -- Do monster insert into msc_system_items for Buyer
125:
126: insert into MSC_SYSTEM_ITEMS(
127: PLAN_ID, ORGANIZATION_ID,
128: INVENTORY_ITEM_ID, SR_INSTANCE_ID,

Line 126: insert into MSC_SYSTEM_ITEMS(

122: and msi.item_name = MSD.ATTRIBUTE3)) MSD1;
123:
124: -- Do monster insert into msc_system_items for Buyer
125:
126: insert into MSC_SYSTEM_ITEMS(
127: PLAN_ID, ORGANIZATION_ID,
128: INVENTORY_ITEM_ID, SR_INSTANCE_ID,
129: SR_INVENTORY_ITEM_ID,ITEM_NAME,
130: LOT_CONTROL_CODE, ROUNDING_CONTROL_TYPE,

Line 177: msc_system_items msi

173: and MSD.ATTRIBUTE8 = 'FORECAST'
174: and not exists ( select 'exists'
175: from msc_st_demands,
176: hz_parties,
177: msc_system_items msi
178: where msi.organization_id = hp.party_id
179: and hp.party_name = MSD.ATTRIBUTE2
180: and hp.party_type = 'ORGANIZATION'
181: and msi.item_name = MSD.ATTRIBUTE3)) MSD1;