eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CUST_FACTS_PVT dependencies on FND_PROFILE

Line 220: AND mtl.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')

216: FROM mtl_item_categories mtl,
217: eni_prod_denorm_hrchy_v eni
218: WHERE mtl.category_set_id = eni.category_set_id
219: AND mtl.category_id = eni.child_id
220: AND mtl.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
221: AND eni.parent_id = p_item_id
222: AND 'PRICING_ATTRIBUTE2' = p_item_type
223: UNION ALL
224: SELECT p_item_id inventory_item_id

Line 266: AND b.data_source = fnd_profile.value('OZF_DASH_BASELINE_SALES_SRC')

262: ozf_baseline_sales_v b
263: WHERE a.report_date = p_report_date
264: AND BITAND(a.record_type_id, 119) = a.record_type_id
265: AND a.time_id = b.time_id
266: AND b.data_source = fnd_profile.value('OZF_DASH_BASELINE_SALES_SRC')
267: AND b.market_type = 'SHIP_TO'
268: AND b.market_id = p_ship_to_site_use_id
269: AND b.item_level = 'PRICING_ATTRIBUTE1'
270: AND b.item_id = p_ITEM_ID

Line 581: AND mtl.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')

577: FROM mtl_item_categories mtl,
578: eni_prod_denorm_hrchy_v eni
579: WHERE mtl.category_set_id = eni.category_set_id
580: AND mtl.category_id = eni.child_id
581: AND mtl.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
582: AND eni.parent_id = p_item_id
583: AND 'PRICING_ATTRIBUTE2' = p_item_type
584: UNION ALL
585: SELECT p_item_id inventory_item_id

Line 618: fnd_profile.value('OZF_TP_COMMON_CURRENCY'),

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)
622: )

Line 620: fnd_profile.value('OZF_CURR_CONVERSION_TYPE'),

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)
622: )
623: , inv_convert.inv_um_convert(a.inventory_item_id,
624: NULL,

Line 627: fnd_profile.value('OZF_TP_COMMON_UOM') ,

623: , inv_convert.inv_um_convert(a.inventory_item_id,
624: NULL,
625: a.ordered_quantity,
626: a.order_quantity_uom,
627: fnd_profile.value('OZF_TP_COMMON_UOM') ,
628: NULL,
629: NULL)
630: ) order_unit,
631: DECODE (ozf_tp_util_queries.get_quota_unit,

Line 635: 'A', fnd_profile.value('OZF_TP_COMMON_CURRENCY')

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)
639: , a.ordered_quantity ) unit

Line 636: , fnd_profile.value('OZF_TP_COMMON_UOM') ) to_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)
639: , a.ordered_quantity ) unit
640: FROM oe_order_lines_all a,

Line 655: fnd_profile.value('OZF_TP_COMMON_CURRENCY'),

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))
659: , inv_convert.inv_um_convert(a.inventory_item_id,

Line 657: fnd_profile.value('OZF_CURR_CONVERSION_TYPE'),

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))
659: , inv_convert.inv_um_convert(a.inventory_item_id,
660: NULL,
661: a.requested_quantity,

Line 663: fnd_profile.value('OZF_TP_COMMON_UOM') ,

659: , inv_convert.inv_um_convert(a.inventory_item_id,
660: NULL,
661: a.requested_quantity,
662: a.requested_quantity_uom,
663: fnd_profile.value('OZF_TP_COMMON_UOM') ,
664: NULL,
665: NULL)
666: )
667: ) , 0 ) requested_quantity

Line 1818: AND mtl.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')

1814: FROM mtl_item_categories mtl,
1815: eni_prod_denorm_hrchy_v eni
1816: WHERE mtl.category_set_id = eni.category_set_id
1817: AND mtl.category_id = eni.child_id
1818: AND mtl.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
1819: AND eni.parent_id = p_item_id
1820: AND 'PRICING_ATTRIBUTE2' = p_item_type
1821: UNION ALL
1822: SELECT p_item_id inventory_item_id