APPS.MSC_IMPORT_ONHAND dependencies on MSC_SYSTEM_ITEMS

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

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:
79: insert into MSC_SYSTEM_ITEMS(
80: PLAN_ID, ORGANIZATION_ID,
81: INVENTORY_ITEM_ID, SR_INSTANCE_ID,

Line 79: insert into MSC_SYSTEM_ITEMS(

75: where item.item_name = MSD.ATTRIBUTE3)) MSD1;
76:
77: -- Do monster insert into msc_system_items for Buyer
78:
79: insert into MSC_SYSTEM_ITEMS(
80: PLAN_ID, ORGANIZATION_ID,
81: INVENTORY_ITEM_ID, SR_INSTANCE_ID,
82: SR_INVENTORY_ITEM_ID,ITEM_NAME,
83: LOT_CONTROL_CODE, ROUNDING_CONTROL_TYPE,

Line 131: msc_system_items msi

127: and not exists
128: ( select 'exists'
129: from MSC_ST_DEMANDS,
130: hz_parties,
131: msc_system_items msi
132: where msi.organization_id = hp.party_id
133: and hp.party_name = MSD.ATTRIBUTE1
134: and hp.party_type = 'ORGANIZATION'
135: and msi.item_name = MSD.ATTRIBUTE3)) MSD1;