DBA Data[Home] [Help]

APPS.MSC_ITEM_PKG dependencies on MSC_CURRENCY_CONV_MV

Line 1590: MSC_CURRENCY_CONV_MV mcc

1586: and bis_mtp.partner_type(+) = 3
1587: and mbid.plan_id=mp.plan_id
1588:
1589: ) pab_tbl,msc_plans mp_tbl,
1590: MSC_CURRENCY_CONV_MV mcc
1591: where mcc.FROM_CURRENCY(+) =pab_tbl.currency_code --- make sure 'xxx' is not a valid currency code
1592: and mcc.TO_CURRENCY(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
1593: and mcc.CALENDAR_DATE(+) = pab_tbl.order_date
1594: and mp_tbl.plan_id = pab_tbl.plan_id ---