APPS.OZF_FORECAST_UTIL_PVT dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

Line 618: ' OZF_OFFER_DISCOUNT_PRODUCTS ODP, '||

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 '||
622: ' AND OFFR.OFFER_ID = ODL.OFFER_ID '||

Line 644: ' OZF_OFFER_DISCOUNT_PRODUCTS PRDODP, '||

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 '||
648: ' AND OFFR.OFFER_ID = ODL.OFFER_ID '||

Line 645: ' OZF_OFFER_DISCOUNT_PRODUCTS EXCODP '||

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 '||
648: ' AND OFFR.OFFER_ID = ODL.OFFER_ID '||
649: ' AND ODL.TIER_TYPE = ''PBH'' '||

Line 8503: OZF_OFFER_DISCOUNT_PRODUCTS ODP,

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
8507: AND OFFR.OFFER_ID = ODL.OFFER_ID

Line 8885: OZF_OFFER_DISCOUNT_PRODUCTS ODP,

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
8889: AND OFFR.OFFER_ID = ODL.OFFER_ID

Line 9681: OZF_OFFER_DISCOUNT_PRODUCTS ODP

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
9685: AND ODL.TIER_TYPE = 'PBH'

Line 9724: OZF_OFFER_DISCOUNT_PRODUCTS ODP,

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
9728: AND OFFR.OFFER_ID = ODL.OFFER_ID