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_OFFER_DISCOUNT_LINES

Line 617: ' OZF_OFFER_DISCOUNT_LINES ODL, '||

613: ' MKT.QUALIFIER_ATTR_VALUE_TO, '||
614: ' MKT.COMPARISON_OPERATOR_CODE '||
615: 'FROM '||
616: ' OZF_OFFERS OFFR, '||
617: ' OZF_OFFER_DISCOUNT_LINES ODL, '||
618: ' OZF_OFFER_DISCOUNT_PRODUCTS ODP, '||
619: ' QP_QUALIFIERS MKT '||
620: 'WHERE ''OFFR'' = :l_object_type '||
621: ' AND OFFR.QP_LIST_HEADER_ID = :l_object_id '||

Line 643: ' OZF_OFFER_DISCOUNT_LINES ODL, '||

639: ' PRDODP.PRODUCT_ATTRIBUTE, '||
640: ' PRDODP.PRODUCT_ATTR_VALUE '||
641: 'FROM '||
642: ' OZF_OFFERS OFFR, '||
643: ' OZF_OFFER_DISCOUNT_LINES ODL, '||
644: ' OZF_OFFER_DISCOUNT_PRODUCTS PRDODP, '||
645: ' OZF_OFFER_DISCOUNT_PRODUCTS EXCODP '||
646: 'WHERE ''OFFR'' = :l_object_type '||
647: ' AND OFFR.QP_LIST_HEADER_ID = :l_object_id '||

Line 8502: OZF_OFFER_DISCOUNT_LINES ODL,

8498: ODL.DISCOUNT_TYPE arithmetic_operator,
8499: MAX(DIS.DISCOUNT) operand
8500: FROM
8501: OZF_OFFERS OFFR,
8502: OZF_OFFER_DISCOUNT_LINES ODL,
8503: OZF_OFFER_DISCOUNT_PRODUCTS ODP,
8504: OZF_OFFER_DISCOUNT_LINES DIS
8505: WHERE
8506: OFFR.QP_LIST_HEADER_ID = p_obj_id

Line 8504: OZF_OFFER_DISCOUNT_LINES DIS

8500: FROM
8501: OZF_OFFERS OFFR,
8502: OZF_OFFER_DISCOUNT_LINES ODL,
8503: OZF_OFFER_DISCOUNT_PRODUCTS ODP,
8504: OZF_OFFER_DISCOUNT_LINES DIS
8505: WHERE
8506: OFFR.QP_LIST_HEADER_ID = p_obj_id
8507: AND OFFR.OFFER_ID = ODL.OFFER_ID
8508: AND ODL.TIER_TYPE = 'PBH'

Line 8884: OZF_OFFER_DISCOUNT_LINES ODL,

8880: ODL.DISCOUNT_TYPE arithmetic_operator,
8881: MAX(DIS.DISCOUNT) operand
8882: FROM
8883: OZF_OFFERS OFFR,
8884: OZF_OFFER_DISCOUNT_LINES ODL,
8885: OZF_OFFER_DISCOUNT_PRODUCTS ODP,
8886: OZF_OFFER_DISCOUNT_LINES DIS
8887: WHERE
8888: OFFR.QP_LIST_HEADER_ID = p_obj_id

Line 8886: OZF_OFFER_DISCOUNT_LINES DIS

8882: FROM
8883: OZF_OFFERS OFFR,
8884: OZF_OFFER_DISCOUNT_LINES ODL,
8885: OZF_OFFER_DISCOUNT_PRODUCTS ODP,
8886: OZF_OFFER_DISCOUNT_LINES DIS
8887: WHERE
8888: OFFR.QP_LIST_HEADER_ID = p_obj_id
8889: AND OFFR.OFFER_ID = ODL.OFFER_ID
8890: AND ODL.TIER_TYPE = 'PBH'

Line 9680: OZF_OFFER_DISCOUNT_LINES ODL,

9676: and fact.arc_act_metric_used_by = 'FCST'
9677: and fact.act_metric_used_by_id = p_forecast_id
9678: AND FACT.ACT_METRIC_USED_BY_ID = FCST.FORECAST_ID
9679: group by fact.fact_reference,fcst.BASE_QUANTITY_TYPE) prod,
9680: OZF_OFFER_DISCOUNT_LINES ODL,
9681: OZF_OFFER_DISCOUNT_PRODUCTS ODP
9682: WHERE prod.forecast_dimention_id = dim.forecast_dimention_id
9683: AND dim.forecast_id = p_forecast_id
9684: AND ODL.OFFER_DISCOUNT_LINE_ID = p_offer_discount_line_id

Line 9723: OZF_OFFER_DISCOUNT_LINES ODL,

9719: ODL.volume_type volume_type,
9720: ODL.uom_code uom_code
9721: FROM
9722: OZF_OFFERS OFFR,
9723: OZF_OFFER_DISCOUNT_LINES ODL,
9724: OZF_OFFER_DISCOUNT_PRODUCTS ODP,
9725: OZF_OFFER_DISCOUNT_LINES DIS
9726: WHERE
9727: OFFR.QP_LIST_HEADER_ID = p_obj_id

Line 9725: OZF_OFFER_DISCOUNT_LINES DIS

9721: FROM
9722: OZF_OFFERS OFFR,
9723: OZF_OFFER_DISCOUNT_LINES ODL,
9724: OZF_OFFER_DISCOUNT_PRODUCTS ODP,
9725: OZF_OFFER_DISCOUNT_LINES DIS
9726: WHERE
9727: OFFR.QP_LIST_HEADER_ID = p_obj_id
9728: AND OFFR.OFFER_ID = ODL.OFFER_ID
9729: AND ODL.TIER_TYPE = 'PBH'