DBA Data[Home] [Help]

APPS.MSC_IMPORT_FORECAST dependencies on MSC_DEMANDS

Line 184: insert into msc_demands(

180: and hp.party_type = 'ORGANIZATION'
181: and msi.item_name = MSD.ATTRIBUTE3)) MSD1;
182:
183: -- Insert forecast entries
184: insert into msc_demands(
185: DEMAND_ID,
186: USING_REQUIREMENT_QUANTITY,
187: ASSEMBLY_DEMAND_COMP_DATE,
188: USING_ASSEMBLY_DEMAND_DATE,

Line 200: select MSC_DEMANDS_S.NEXTVAL,

196: LAST_UPDATE_DATE,
197: LAST_UPDATED_BY,
198: CREATION_DATE,
199: CREATED_BY)
200: select MSC_DEMANDS_S.NEXTVAL,
201: TO_NUMBER(MSD.ATTRIBUTE7),
202: TO_DATE(MSD.ATTRIBUTE6, 'MM/DD/YYYY'),
203: TO_DATE(MSD.ATTRIBUTE5, 'MM/DD/YYYY'),
204: TO_NUMBER(MSD.ATTRIBUTE12),