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

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

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

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

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

2897: )
2898: IS
2899: CURSOR c_adjLines(cp_offerAdjustmentId NUMBER) IS
2900: SELECT offer_adj_new_line_id
2901: FROM ozf_offer_adj_new_lines
2902: WHERE tier_type <> 'DIS'
2903: AND offer_adjustment_id = cp_offerAdjustmentId;
2904: BEGIN
2905: -- initialize

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

3118: )
3119: IS
3120: CURSOR c_adjLines(cp_offerAdjustmentId NUMBER) IS
3121: SELECT offer_adj_new_line_id
3122: FROM ozf_offer_adj_new_lines
3123: WHERE tier_type = 'DIS'
3124: AND offer_adjustment_id = cp_offerAdjustmentId;
3125: BEGIN
3126: -- initialize

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 3403: ozf_offer_adj_new_lines a, ozf_offer_adjustments_b b, ozf_offers c

3399: , b.list_header_id
3400: , decode(c.offer_type,'ACCRUAL','Y','N') accrual_flag
3401: , c.modifier_level_code
3402: FROM
3403: ozf_offer_adj_new_lines a, ozf_offer_adjustments_b b, ozf_offers c
3404: WHERE a.offer_adjustment_id = b.offer_adjustment_id
3405: AND b.list_header_id = c.qp_list_header_id
3406: AND a.offer_adj_new_line_id = cp_offerAdjNewLineId;
3407: 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 3497: FROM ozf_offer_adj_new_lines a

3493: --, c.list_header_id
3494: --, d.modifier_level_code
3495: --, decode(d.offer_type, 'ACCRUAL','Y','N') accrual_flag
3496: , a.end_date_active
3497: FROM ozf_offer_adj_new_lines a
3498: WHERE a.offer_adj_new_line_id = cp_offerAdjNewLineId;
3499:
3500: BEGIN
3501: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3564: FROM ozf_offer_adj_new_lines

3560: SELECT
3561: discount
3562: , discount_type
3563: , tier_type
3564: FROM ozf_offer_adj_new_lines
3565: WHERE offer_adj_new_line_id = cp_offerAdjNewLineId;
3566:
3567: BEGIN
3568: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3651: )
3652: IS
3653: CURSOR c_adjNewLines(cp_offerAdjNewLineId NUMBER) IS
3654: SELECT offer_adj_new_line_id
3655: FROM ozf_offer_adj_new_lines
3656: WHERE parent_adj_line_id = cp_offerAdjNewLineId;
3657: i NUMBER;
3658: BEGIN
3659: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3946: FROM ozf_offer_adj_new_lines

3942: )
3943: IS
3944: CURSOR c_adjustmentProducts(cp_offerAdjustmentId NUMBER) IS
3945: SELECT offer_adj_new_line_id
3946: FROM ozf_offer_adj_new_lines
3947: WHERE tier_type = 'DIS'
3948: AND parent_adj_line_id IS NULL
3949: AND offer_adjustment_id = cp_offerAdjustmentId;
3950: BEGIN

Line 3979: FROM ozf_offer_adj_new_lines

3975: IS
3976: CURSOR c_adjustmentProducts(cp_offerAdjustmentId NUMBER)
3977: IS
3978: SELECT offer_adj_new_line_id
3979: FROM ozf_offer_adj_new_lines
3980: WHERE offer_adjustment_id = cp_offerAdjustmentId
3981: AND parent_adj_line_id IS NULL
3982: AND tier_type = 'PBH';
3983: