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 2716: ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b , ozf_offer_adjustments_b c

2712: , b.end_date_active
2713: , c.effective_date
2714: , c.list_header_id
2715: FROM
2716: ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b , ozf_offer_adjustments_b c
2717: WHERE a.offer_adj_new_line_id = b.offer_adj_new_line_id
2718: AND a.excluder_flag = 'N'
2719: AND b.offer_adjustment_id = c.offer_adjustment_id
2720: AND b.offer_adj_new_line_id = cp_offerAdjNewLineId;

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

2941: , b.product_attr_value
2942: , b.uom_code
2943: , c.effective_date
2944: , c.list_header_id
2945: FROM ozf_offer_adj_new_lines a, ozf_offer_adj_new_products b, ozf_offer_adjustments_b c
2946: WHERE a.offer_adj_new_line_id = b.offer_adj_new_line_id
2947: AND a.offer_adjustment_id = c.offer_adjustment_id
2948: AND a.offer_adj_new_line_id = cp_offerAdjNewLineId;
2949:

Line 3227: ozf_offer_adj_new_lines a, ozf_offer_adj_new_products b , ozf_offer_adjustments_b c

3223: , b.uom_code
3224: , c.list_header_id
3225: , c.effective_date
3226: FROM
3227: ozf_offer_adj_new_lines a, ozf_offer_adj_new_products b , ozf_offer_adjustments_b c
3228: WHERE a.offer_adj_new_line_id = b.offer_adj_new_line_id
3229: AND a.offer_adjustment_id = c.offer_adjustment_id
3230: and a.offer_adj_new_line_id = cp_offerAdjNewLineId;
3231: i NUMBER;

Line 3455: FROM ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b

3451: , a.product_attr_value
3452: , a.uom_code
3453: , a.excluder_flag
3454: , b.volume_type
3455: FROM ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b
3456: WHERE
3457: a.offer_adj_new_line_id = b.offer_adj_new_line_id
3458: AND a.offer_adj_new_line_id = cp_offerAdjNewLineId;
3459: i NUMBER;

Line 3616: FROM ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b

3612: , a.excluder_flag
3613: , b.volume_type
3614: , b.volume_from
3615: , b.volume_to
3616: FROM ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b
3617: WHERE
3618: a.offer_adj_new_line_id = b.parent_adj_line_id
3619: AND a.excluder_flag = 'N'
3620: AND b.offer_adj_new_line_id = cp_offerAdjNewLineId;

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

3802: END IF;
3803: END populateNewMtProducts;
3804:
3805: /**
3806: Creates a multi-tier discount line in QP corresponding to data entered in ozf_offer_adj_new_lines and ozf_offer_adj_new_products
3807: * p_offerAdjNewLineId offer_adj_new_line_id for which the qp data is to be created
3808: * 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.
3809: */
3810: PROCEDURE createNewMtProduct