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_FORECAST_UTIL_PVT dependencies on OZF_ACT_OFFERS

Line 459: ' ozf_act_offers off, '||

455: ' mkt.QUALIFIER_ATTR_VALUE_TO, '||
456: ' mkt.COMPARISON_OPERATOR_CODE '||
457: 'from qp_pricing_attributes prd, '||
458: ' qp_qualifiers mkt, '||
459: ' ozf_act_offers off, '||
460: ' qp_list_lines ln '||
461: 'where off.arc_act_offer_used_by = :l_object_type '||
462: 'and off.act_offer_used_by_id = :l_object_id '||
463: 'and off.qp_list_header_id = prd.list_header_id '||

Line 488: ' ozf_act_offers off '||

484: ' prd.PRODUCT_ATTRIBUTE, '||
485: ' prd.PRODUCT_ATTR_VALUE ' ||
486: 'from qp_pricing_attributes prd, '||
487: ' qp_pricing_attributes exp,'||
488: ' ozf_act_offers off '||
489: 'where off.arc_act_offer_used_by = :l_object_type '||
490: 'and off.act_offer_used_by_id = :l_object_id '||
491: 'and off.qp_list_header_id = prd.list_header_id '||
492: 'and prd.excluder_flag = ''Y'' '||

Line 8857: ozf_act_offers a

8853: qpl.operand,
8854: qpl.arithmetic_operator
8855: FROM qp_pricing_attributes pa,
8856: qp_list_lines qpl,
8857: ozf_act_offers a
8858: WHERE a.arc_act_offer_used_by = p_obj_type
8859: AND a.act_offer_used_by_id = p_obj_id
8860: AND qpl.list_header_id = a.qp_list_header_id
8861: AND qpl.list_line_id = pa.list_line_id