eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_IMPORT_ONHAND dependencies on MSC_SUPPLIES

Line 137: -- Insert Onhand into msc_supplies

133: and hp.party_name = MSD.ATTRIBUTE1
134: and hp.party_type = 'ORGANIZATION'
135: and msi.item_name = MSD.ATTRIBUTE3)) MSD1;
136:
137: -- Insert Onhand into msc_supplies
138:
139: insert into msc_supplies(
140: PLAN_ID,
141: TRANSACTION_ID,

Line 139: insert into msc_supplies(

135: and msi.item_name = MSD.ATTRIBUTE3)) MSD1;
136:
137: -- Insert Onhand into msc_supplies
138:
139: insert into msc_supplies(
140: PLAN_ID,
141: TRANSACTION_ID,
142: ORGANIZATION_ID,
143: SR_INSTANCE_ID,

Line 154: MSC_SUPPLIES_S.NEXTVAL,

150: LAST_UPDATED_BY,
151: CREATION_DATE,
152: CREATED_BY)
153: select TO_NUMBER(MSD.ATTRIBUTE9),
154: MSC_SUPPLIES_S.NEXTVAL,
155: hz.party_id,
156: TO_NUMBER(MSD.ATTRIBUTE10),
157: mi.inventory_item_id,
158: TO_DATE(MSD.ATTRIBUTE5, 'MM/DD/YYYY'),

Line 203: from msc_supplies

199: l_onhand number := 0;
200: begin
201: select sum(nvl(new_order_quantity,0))
202: into l_onhand
203: from msc_supplies
204: where plan_id = arg_plan_id
205: and organization_id = arg_org_id
206: and sr_instance_id = arg_instance
207: and inventory_item_id = arg_item_id