DBA Data[Home] [Help]

APPS.OZF_CUST_FACTS_PVT dependencies on GL_CURRENCY_API

Line 617: 'A', gl_currency_api.convert_amount_sql( b.transactional_curr_code,

613: a.request_date,
614: a.promise_date,
615: a.schedule_ship_date,
616: DECODE( ozf_tp_util_queries.get_quota_unit,
617: 'A', gl_currency_api.convert_amount_sql( b.transactional_curr_code,
618: fnd_profile.value('OZF_TP_COMMON_CURRENCY'),
619: a.request_date,
620: fnd_profile.value('OZF_CURR_CONVERSION_TYPE'),
621: (a.ordered_quantity*a.unit_selling_price)

Line 654: 'A', gl_currency_api.convert_amount_sql( a.currency_code,

650: CURSOR backorder_csr( p_line_id NUMBER) IS
651: SELECT NVL(
652: SUM(
653: DECODE (ozf_tp_util_queries.get_quota_unit,
654: 'A', gl_currency_api.convert_amount_sql( a.currency_code,
655: fnd_profile.value('OZF_TP_COMMON_CURRENCY'),
656: a.date_requested,
657: fnd_profile.value('OZF_CURR_CONVERSION_TYPE'),
658: (a.requested_quantity*a.unit_price))