DBA Data[Home] [Help]

APPS.MSC_DEMAND_PKG dependencies on MSC_CURRENCY_CONV_MV

Line 918: MSC_CURRENCY_CONV_MV mcc,msc_phub_customers_mv cmv

914: -1 * md1.origination_type,
915: msi1.vmi_flag,
916: nvl(mtp1.currency_code, l_owning_currency_code)
917: order by 1,2,3,4,5,6,7,8,9,10,11,12,13) demand_tbl,msc_plans mp_tbl,
918: MSC_CURRENCY_CONV_MV mcc,msc_phub_customers_mv cmv
919: where
920: mcc.FROM_CURRENCY(+) =demand_tbl.currency_code -- make sure 'XXX' is not a valid currency code
921: and mcc.TO_CURRENCY(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
922: and mcc.CALENDAR_DATE (+)= demand_tbl.order_date