[Home] [Help]
133: and k.inventory_item_id = f.inventory_item_id(+)
134: and k.demand_class = f.demand_class(+)
135: and k.start_date = f.start_date(+)) t,
136: msc_currency_conv_mv mcc,
137: msc_phub_customers_mv mpc
138: where mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
139: and mcc.from_currency(+) = t.currency_code
140: and mcc.calendar_date(+) = t.start_date
141: and mpc.customer_id = t.customer_id