APPS.OZF_CUST_FACTS_PVT dependencies on OZF_TP_UTIL_QUERIES

Line 616: DECODE( ozf_tp_util_queries.get_quota_unit,

612: SELECT a.line_id,
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'),

Line 631: DECODE (ozf_tp_util_queries.get_quota_unit,

627: fnd_profile.value('OZF_TP_COMMON_UOM') ,
628: NULL,
629: NULL)
630: ) order_unit,
631: DECODE (ozf_tp_util_queries.get_quota_unit,
632: 'A', b.transactional_curr_code
633: , a.order_quantity_uom) from_unit,
634: DECODE (ozf_tp_util_queries.get_quota_unit,
635: 'A', fnd_profile.value('OZF_TP_COMMON_CURRENCY')

Line 634: DECODE (ozf_tp_util_queries.get_quota_unit,

630: ) order_unit,
631: DECODE (ozf_tp_util_queries.get_quota_unit,
632: 'A', b.transactional_curr_code
633: , a.order_quantity_uom) from_unit,
634: DECODE (ozf_tp_util_queries.get_quota_unit,
635: 'A', fnd_profile.value('OZF_TP_COMMON_CURRENCY')
636: , fnd_profile.value('OZF_TP_COMMON_UOM') ) to_unit,
637: DECODE (ozf_tp_util_queries.get_quota_unit,
638: 'A', (a.ordered_quantity*a.unit_selling_price)

Line 637: DECODE (ozf_tp_util_queries.get_quota_unit,

633: , a.order_quantity_uom) from_unit,
634: DECODE (ozf_tp_util_queries.get_quota_unit,
635: 'A', fnd_profile.value('OZF_TP_COMMON_CURRENCY')
636: , fnd_profile.value('OZF_TP_COMMON_UOM') ) to_unit,
637: DECODE (ozf_tp_util_queries.get_quota_unit,
638: 'A', (a.ordered_quantity*a.unit_selling_price)
639: , a.ordered_quantity ) unit
640: FROM oe_order_lines_all a,
641: oe_order_headers_all b

Line 653: DECODE (ozf_tp_util_queries.get_quota_unit,

649:
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'),