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_LINES

Line 26: FROM ozf_offer_adj_new_lines

22: IS
23: CURSOR c_offerAdjustmentId(cp_offerAdjNewLineId NUMBER)
24: IS
25: SELECT offer_adjustment_id
26: FROM ozf_offer_adj_new_lines
27: WHERE offer_adj_new_line_id = cp_offerAdjNewLineId;
28: l_offerAdjustmentId NUMBER;
29: BEGIN
30: OPEN c_offerAdjustmentId(cp_offerAdjNewLineId => p_offerAdjNewLineId);

Line 47: FROM ozf_offers a, ozf_offer_adjustments_b b, ozf_offer_adj_new_lines c

43: RETURN VARCHAR2
44: IS
45: CURSOR c_offerType(cp_offerAdjNewLineId NUMBER) IS
46: SELECT offer_type
47: FROM ozf_offers a, ozf_offer_adjustments_b b, ozf_offer_adj_new_lines c
48: WHERE
49: a.qp_list_header_id = b.list_header_id
50: AND b.offer_adjustment_id = c.offer_adjustment_id
51: AND c.offer_adj_new_line_id = cp_offerAdjNewLineId;

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 3185: FROM ozf_offer_adj_new_lines

3181: )
3182: IS
3183: CURSOR c_adjLines(cp_offerAdjustmentId NUMBER) IS
3184: SELECT offer_adj_new_line_id
3185: FROM ozf_offer_adj_new_lines
3186: WHERE tier_type <> 'DIS'
3187: AND offer_adjustment_id = cp_offerAdjustmentId;
3188: BEGIN
3189: -- initialize

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 3406: FROM ozf_offer_adj_new_lines

3402: )
3403: IS
3404: CURSOR c_adjLines(cp_offerAdjustmentId NUMBER) IS
3405: SELECT offer_adj_new_line_id
3406: FROM ozf_offer_adj_new_lines
3407: WHERE tier_type = 'DIS'
3408: AND offer_adjustment_id = cp_offerAdjustmentId;
3409: BEGIN
3410: -- initialize

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 3554: FROM ozf_offer_adj_new_lines l

3550: l_endDate DATE;
3551:
3552: CURSOR c_endDate IS
3553: SELECT TRUNC(l.end_date_active)
3554: FROM ozf_offer_adj_new_lines l
3555: WHERE l.offer_adj_new_line_id = p_offerAdjNewLineId;
3556:
3557: BEGIN
3558: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3949: ozf_offer_adj_new_lines a, ozf_offer_adjustments_b b, ozf_offers c

3945: , b.list_header_id
3946: , decode(c.offer_type,'ACCRUAL','Y','N') accrual_flag
3947: , c.modifier_level_code
3948: FROM
3949: ozf_offer_adj_new_lines a, ozf_offer_adjustments_b b, ozf_offers c
3950: WHERE a.offer_adjustment_id = b.offer_adjustment_id
3951: AND b.list_header_id = c.qp_list_header_id
3952: AND a.offer_adj_new_line_id = cp_offerAdjNewLineId;
3953: 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 4043: FROM ozf_offer_adj_new_lines a

4039: --, c.list_header_id
4040: --, d.modifier_level_code
4041: --, decode(d.offer_type, 'ACCRUAL','Y','N') accrual_flag
4042: , a.end_date_active
4043: FROM ozf_offer_adj_new_lines a
4044: WHERE a.offer_adj_new_line_id = cp_offerAdjNewLineId;
4045:
4046: BEGIN
4047: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4110: FROM ozf_offer_adj_new_lines

4106: SELECT
4107: discount
4108: , discount_type
4109: , tier_type
4110: FROM ozf_offer_adj_new_lines
4111: WHERE offer_adj_new_line_id = cp_offerAdjNewLineId;
4112:
4113: BEGIN
4114: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 4201: FROM ozf_offer_adj_new_lines

4197: )
4198: IS
4199: CURSOR c_adjNewLines(cp_offerAdjNewLineId NUMBER) IS
4200: SELECT offer_adj_new_line_id
4201: FROM ozf_offer_adj_new_lines
4202: WHERE parent_adj_line_id = cp_offerAdjNewLineId;
4203: i NUMBER;
4204: BEGIN
4205: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4492: FROM ozf_offer_adj_new_lines

4488: )
4489: IS
4490: CURSOR c_adjustmentProducts(cp_offerAdjustmentId NUMBER) IS
4491: SELECT offer_adj_new_line_id
4492: FROM ozf_offer_adj_new_lines
4493: WHERE tier_type = 'DIS'
4494: AND parent_adj_line_id IS NULL
4495: AND offer_adjustment_id = cp_offerAdjustmentId;
4496: BEGIN

Line 4525: FROM ozf_offer_adj_new_lines

4521: IS
4522: CURSOR c_adjustmentProducts(cp_offerAdjustmentId NUMBER)
4523: IS
4524: SELECT offer_adj_new_line_id
4525: FROM ozf_offer_adj_new_lines
4526: WHERE offer_adjustment_id = cp_offerAdjustmentId
4527: AND parent_adj_line_id IS NULL
4528: AND tier_type = 'PBH';
4529: