[Home] [Help]
200: mtp.currency_code,
201: t.date1,
202: t.exception_type
203: ) exception_tbl,
204: msc_currency_conv_mv mcc
205: where mcc.FROM_CURRENCY(+) = nvl(exception_tbl.currency_code, 'XXX')
206: and mcc.TO_CURRENCY(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
207: and mcc.CALENDAR_DATE(+) = exception_tbl.analysis_date;
208:
315: and mdr.sr_instance_id = mdrs.sr_instance_id
316: and mdr.organization_id = mdrs.organization_id
317: and mdr.department_id = mdrs.department_id
318: and mdr.resource_id = mdrs.resource_id) t1,
319: msc_currency_conv_mv mcc
320: where mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
321: and mcc.from_currency(+) = nvl(t1.currency_code, 'XXX')
322: and mcc.calendar_date(+) = t1.resource_date
323: )
476: nvl(ms.supplier_site_id, -23453),
477: ms.inventory_item_id,
478: trunc(ms.new_schedule_date)
479: ) t1,
480: msc_currency_conv_mv mcc
481: where mcc.to_currency(+) = FND_PROFILE.value('MSC_HUB_CUR_CODE_RPT')
482: and mcc.from_currency(+) = t1.currency_code
483: and mcc.calendar_date(+) = trunc(t1.analysis_date)
484: group by
585: trunc(nvl(md.firm_date, md.using_assembly_demand_date)),
586: md.origination_type) t1,
587: msc_system_items msi,
588: msc_plans mp,
589: msc_currency_conv_mv mcc
590: where msi.plan_id = t1.plan_id
591: and msi.sr_instance_id = decode(sign(t1.sr_instance_id), -1, mp.sr_instance_id, t1.sr_instance_id) --wei
592: and msi.organization_id = decode(sign(t1.organization_id), -1, mp.organization_id, t1.organization_id) --wei
593: and msi.inventory_item_id = t1.inventory_item_id
864: and mbid.sr_instance_id = bis_mtp.sr_instance_id
865: and mbid.organization_id = bis_mtp.sr_tp_id
866: and bis_mtp.partner_type = 3
867: ) pab_tbl,
868: msc_currency_conv_mv mcc
869: where mcc.from_currency(+) =pab_tbl.currency_code --- make sure 'xxx' is not a valid currency code
870: and mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
871: and mcc.calendar_date(+) = pab_tbl.order_date
872: group by