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_OFFER_ADJ_PVT dependencies on OZF_OFFER_ADJ_NEW_PRODUCTS

Line 3000: ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b , ozf_offer_adjustments_b c

2996: , b.end_date_active
2997: , c.effective_date
2998: , c.list_header_id
2999: FROM
3000: ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b , ozf_offer_adjustments_b c
3001: WHERE a.offer_adj_new_line_id = b.offer_adj_new_line_id
3002: AND a.excluder_flag = 'N'
3003: AND b.offer_adjustment_id = c.offer_adjustment_id
3004: AND b.offer_adj_new_line_id = cp_offerAdjNewLineId;

Line 3229: FROM ozf_offer_adj_new_lines a, ozf_offer_adj_new_products b, ozf_offer_adjustments_b c

3225: , b.product_attr_value
3226: , b.uom_code
3227: , c.effective_date
3228: , c.list_header_id
3229: FROM ozf_offer_adj_new_lines a, ozf_offer_adj_new_products b, ozf_offer_adjustments_b c
3230: WHERE a.offer_adj_new_line_id = b.offer_adj_new_line_id
3231: AND a.offer_adjustment_id = c.offer_adjustment_id
3232: AND a.offer_adj_new_line_id = cp_offerAdjNewLineId;
3233:

Line 3511: ozf_offer_adj_new_lines a, ozf_offer_adj_new_products b , ozf_offer_adjustments_b c

3507: , b.uom_code
3508: , c.list_header_id
3509: , c.effective_date
3510: FROM
3511: ozf_offer_adj_new_lines a, ozf_offer_adj_new_products b , ozf_offer_adjustments_b c
3512: WHERE a.offer_adj_new_line_id = b.offer_adj_new_line_id
3513: AND a.offer_adjustment_id = c.offer_adjustment_id
3514: and a.offer_adj_new_line_id = cp_offerAdjNewLineId;
3515: i NUMBER;

Line 4001: FROM ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b

3997: , a.product_attr_value
3998: , a.uom_code
3999: , a.excluder_flag
4000: , b.volume_type
4001: FROM ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b
4002: WHERE
4003: a.offer_adj_new_line_id = b.offer_adj_new_line_id
4004: AND a.offer_adj_new_line_id = cp_offerAdjNewLineId;
4005: i NUMBER;

Line 4162: FROM ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b

4158: , a.excluder_flag
4159: , b.volume_type
4160: , b.volume_from
4161: , b.volume_to
4162: FROM ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b
4163: WHERE
4164: a.offer_adj_new_line_id = b.parent_adj_line_id
4165: AND a.excluder_flag = 'N'
4166: AND b.offer_adj_new_line_id = cp_offerAdjNewLineId;

Line 4352: Creates a multi-tier discount line in QP corresponding to data entered in ozf_offer_adj_new_lines and ozf_offer_adj_new_products

4348: END IF;
4349: END populateNewMtProducts;
4350:
4351: /**
4352: Creates a multi-tier discount line in QP corresponding to data entered in ozf_offer_adj_new_lines and ozf_offer_adj_new_products
4353: * p_offerAdjNewLineId offer_adj_new_line_id for which the qp data is to be created
4354: * note as of now the price_break_type_code is not captured in the UI or in the database so it is hardcoded to point.
4355: */
4356: PROCEDURE createNewMtProduct