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.OE_LINE_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 4215: FROM oe_price_adjustments prg, oe_price_adj_assocs a,

4211:
4212:
4213: SELECT 'Y'
4214: INTO l_prg
4215: FROM oe_price_adjustments prg, oe_price_adj_assocs a,
4216: oe_price_adjustments p
4217: WHERE prg.line_id = p_x_line_rec.service_reference_line_id
4218: AND prg.list_line_type_code = 'PRG'
4219: AND prg.price_adjustment_id = a.price_adjustment_id

Line 4216: oe_price_adjustments p

4212:
4213: SELECT 'Y'
4214: INTO l_prg
4215: FROM oe_price_adjustments prg, oe_price_adj_assocs a,
4216: oe_price_adjustments p
4217: WHERE prg.line_id = p_x_line_rec.service_reference_line_id
4218: AND prg.list_line_type_code = 'PRG'
4219: AND prg.price_adjustment_id = a.price_adjustment_id
4220: AND p.price_adjustment_id = a.rltd_price_adj_id

Line 6353: from oe_price_adjustments where

6349: AND p_old_line_rec.freight_terms_code <> FND_API.G_MISS_CHAR)))
6350: THEN
6351: IF OE_GLOBALS.G_FTE_REINVOKE IS NULL THEN
6352: Select Count(*) into l_fte_count
6353: from oe_price_adjustments where
6354: header_id = p_x_line_rec.header_id
6355: and LIST_LINE_TYPE_CODE = 'OM_CALLED_CHOOSE_SHIP_METHOD';
6356: if l_debug_level > 0 then
6357: oe_debug_pub.add( 'Value of fte count '||l_fte_count);

Line 18007: select count(*) into v_count from oe_price_adjustments

18003: IF (nvl(p_x_line_rec.split_by,'X') <> 'SYSTEM' and
18004: NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT') THEN
18005:
18006: --bug 4190357
18007: select count(*) into v_count from oe_price_adjustments
18008: where line_id = p_x_line_rec.line_id
18009: and substitution_attribute = 'QUALIFIER_ATTRIBUTE11'
18010: and list_line_type_code = 'TSN'
18011: and modified_to = p_x_line_rec.shipping_method_code;

Line 18016: DELETE FROM OE_PRICE_ADJUSTMENTS

18012: IF v_count > 0 THEN
18013: IF l_debug_level > 0 THEN
18014: oe_debug_pub.add('Deleting the tsn adjustments');
18015: END IF;
18016: DELETE FROM OE_PRICE_ADJUSTMENTS
18017: WHERE LINE_ID = p_x_line_rec.line_id
18018: AND LIST_LINE_TYPE_CODE = 'TSN'
18019: AND SUBSTITUTION_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE11'
18020: AND MODIFIED_TO = p_x_line_rec.shipping_method_code

Line 23970: oe_price_adjustments opa1,

23966: --parent line assocation id through the OE_PRICE_ADJ_ASSOCS table
23967: CURSOR C1 IS
23968: SELECT opa1.price_adjustment_id, opa2.price_adjustment_id, opa1.line_id
23969: FROM
23970: oe_price_adjustments opa1,
23971: oe_price_adj_assocs opaa,
23972: oe_price_adjustments opa2
23973: WHERE
23974: opa1.line_id = p_old_line_rec.line_id

Line 23972: oe_price_adjustments opa2

23968: SELECT opa1.price_adjustment_id, opa2.price_adjustment_id, opa1.line_id
23969: FROM
23970: oe_price_adjustments opa1,
23971: oe_price_adj_assocs opaa,
23972: oe_price_adjustments opa2
23973: WHERE
23974: opa1.line_id = p_old_line_rec.line_id
23975: AND opa1.price_adjustment_id = opaa.rltd_price_adj_id
23976: AND opaa.price_adjustment_id = opa2.price_adjustment_id

Line 23982: FROM oe_price_adjustments

23978:
23979: --cursor to find the IUE adjustments for this line
23980: CURSOR c2 IS
23981: SELECT price_adjustment_id
23982: FROM oe_price_adjustments
23983: where line_id=p_old_line_rec.line_id AND list_line_type_code='IUE';
23984:
23985: --variables to read the cursor C1 into
23986: parent_adj_id oe_price_adjustments.price_adjustment_id%TYPE;

Line 23986: parent_adj_id oe_price_adjustments.price_adjustment_id%TYPE;

23982: FROM oe_price_adjustments
23983: where line_id=p_old_line_rec.line_id AND list_line_type_code='IUE';
23984:
23985: --variables to read the cursor C1 into
23986: parent_adj_id oe_price_adjustments.price_adjustment_id%TYPE;
23987: child_adj_id oe_price_adjustments.price_adjustment_id%TYPE;
23988: child_line_id oe_price_adjustments.line_id%TYPE;
23989:
23990: iue_adj_id oe_price_adjustments.price_adjustment_id%TYPE;

Line 23987: child_adj_id oe_price_adjustments.price_adjustment_id%TYPE;

23983: where line_id=p_old_line_rec.line_id AND list_line_type_code='IUE';
23984:
23985: --variables to read the cursor C1 into
23986: parent_adj_id oe_price_adjustments.price_adjustment_id%TYPE;
23987: child_adj_id oe_price_adjustments.price_adjustment_id%TYPE;
23988: child_line_id oe_price_adjustments.line_id%TYPE;
23989:
23990: iue_adj_id oe_price_adjustments.price_adjustment_id%TYPE;
23991: app_f oe_price_adjustments.applied_flag%TYPE;

Line 23988: child_line_id oe_price_adjustments.line_id%TYPE;

23984:
23985: --variables to read the cursor C1 into
23986: parent_adj_id oe_price_adjustments.price_adjustment_id%TYPE;
23987: child_adj_id oe_price_adjustments.price_adjustment_id%TYPE;
23988: child_line_id oe_price_adjustments.line_id%TYPE;
23989:
23990: iue_adj_id oe_price_adjustments.price_adjustment_id%TYPE;
23991: app_f oe_price_adjustments.applied_flag%TYPE;
23992: up_f oe_price_adjustments.updated_flag%TYPE;

Line 23990: iue_adj_id oe_price_adjustments.price_adjustment_id%TYPE;

23986: parent_adj_id oe_price_adjustments.price_adjustment_id%TYPE;
23987: child_adj_id oe_price_adjustments.price_adjustment_id%TYPE;
23988: child_line_id oe_price_adjustments.line_id%TYPE;
23989:
23990: iue_adj_id oe_price_adjustments.price_adjustment_id%TYPE;
23991: app_f oe_price_adjustments.applied_flag%TYPE;
23992: up_f oe_price_adjustments.updated_flag%TYPE;
23993: row_count NUMBER;
23994:

Line 23991: app_f oe_price_adjustments.applied_flag%TYPE;

23987: child_adj_id oe_price_adjustments.price_adjustment_id%TYPE;
23988: child_line_id oe_price_adjustments.line_id%TYPE;
23989:
23990: iue_adj_id oe_price_adjustments.price_adjustment_id%TYPE;
23991: app_f oe_price_adjustments.applied_flag%TYPE;
23992: up_f oe_price_adjustments.updated_flag%TYPE;
23993: row_count NUMBER;
23994:
23995: BEGIN

Line 23992: up_f oe_price_adjustments.updated_flag%TYPE;

23988: child_line_id oe_price_adjustments.line_id%TYPE;
23989:
23990: iue_adj_id oe_price_adjustments.price_adjustment_id%TYPE;
23991: app_f oe_price_adjustments.applied_flag%TYPE;
23992: up_f oe_price_adjustments.updated_flag%TYPE;
23993: row_count NUMBER;
23994:
23995: BEGIN
23996: oe_debug_pub.ADD('Entering OE_LINE_UTIL.UPDATE_ADJUSTMENT_FLAGS',1);

Line 24006: /* DELETE FROM oe_price_adjustments

24002: RETURN;
24003: END IF;
24004:
24005: --deleting the IUE adjustment
24006: /* DELETE FROM oe_price_adjustments
24007: where line_id=p_old_line_rec.line_id AND list_line_type_code='IUE';*/
24008:
24009: oe_debug_pub.ADD('trying to delete IUE adjustments...',1);
24010: OPEN c2;

Line 24041: FROM oe_price_adj_assocs opaa,oe_price_adjustments opa

24037:
24038: --Find out the number of free items adjustments associated with this parent
24039: --(other then this item, we already deleted its adjustment)
24040: SELECT COUNT(*) INTO row_count
24041: FROM oe_price_adj_assocs opaa,oe_price_adjustments opa
24042: WHERE opaa.price_adjustment_id=parent_adj_id
24043: AND opaa.rltd_price_adj_id=opa.price_adjustment_id;
24044: oe_debug_pub.ADD('total '||row_count||' free child record(s)',1);
24045:

Line 24048: UPDATE oe_price_adjustments

24044: oe_debug_pub.ADD('total '||row_count||' free child record(s)',1);
24045:
24046: IF row_count>0 THEN
24047: --not the only free item, this adjustment is applied _and_ updated = 'Y'
24048: UPDATE oe_price_adjustments
24049: SET applied_flag='Y',updated_flag='Y'
24050: WHERE price_adjustment_id=parent_adj_id;
24051: oe_debug_pub.ADD('updated parent adjustment: applied_flag=Y,updated_flag=Y:'||SQL%rowcount||' row(s)',1);
24052: UPDATE oe_price_adjustments

Line 24052: UPDATE oe_price_adjustments

24048: UPDATE oe_price_adjustments
24049: SET applied_flag='Y',updated_flag='Y'
24050: WHERE price_adjustment_id=parent_adj_id;
24051: oe_debug_pub.ADD('updated parent adjustment: applied_flag=Y,updated_flag=Y:'||SQL%rowcount||' row(s)',1);
24052: UPDATE oe_price_adjustments
24053: SET updated_flag = 'Y' where price_adjustment_id in
24054: (select rltd_price_adj_id from oe_price_adj_assocs
24055: where price_adjustment_id = parent_adj_id);
24056: ELSE

Line 24058: UPDATE oe_price_adjustments

24054: (select rltd_price_adj_id from oe_price_adj_assocs
24055: where price_adjustment_id = parent_adj_id);
24056: ELSE
24057: --the last (or only) free item, make parent adjustment applied='N'
24058: UPDATE oe_price_adjustments
24059: SET applied_flag='N',updated_flag='Y'
24060: WHERE price_adjustment_id=parent_adj_id;
24061: oe_debug_pub.ADD('updated parent adjustment: applied_flag=N,updated_flag=Y:'||SQL%rowcount||' rows',1);
24062: END IF;

Line 24064: FROM oe_price_adjustments

24060: WHERE price_adjustment_id=parent_adj_id;
24061: oe_debug_pub.ADD('updated parent adjustment: applied_flag=N,updated_flag=Y:'||SQL%rowcount||' rows',1);
24062: END IF;
24063: SELECT applied_flag,updated_flag INTO app_f,up_f
24064: FROM oe_price_adjustments
24065: WHERE price_adjustment_id=parent_adj_id;
24066: oe_debug_pub.ADD('price_adjustment_id:'||parent_adj_id||' applied_flag='||app_f||' updated_flag='||up_f,1);
24067:
24068:

Line 24837: oe_price_adjustments p,

24833:
24834: SELECT a.price_adjustment_id,a.rltd_price_adj_id,prg.list_line_id,p.list_line_id
24835: INTO l_orig_pr_adjustment_id,l_or_rltd_padj_id,l_prg_list_line_id,l_assoc_list_line_id
24836: FROM oe_price_adj_assocs a,
24837: oe_price_adjustments p,
24838: oe_order_lines_all l,
24839: oe_price_adjustments prg
24840: WHERE l.line_id = p.line_id AND p.price_adjustment_id = a.rltd_price_adj_id
24841: AND l.item_type_code = 'SERVICE' AND l.SUBSCRIPTION_ENABLE_FLAG <> 'Y'

Line 24839: oe_price_adjustments prg

24835: INTO l_orig_pr_adjustment_id,l_or_rltd_padj_id,l_prg_list_line_id,l_assoc_list_line_id
24836: FROM oe_price_adj_assocs a,
24837: oe_price_adjustments p,
24838: oe_order_lines_all l,
24839: oe_price_adjustments prg
24840: WHERE l.line_id = p.line_id AND p.price_adjustment_id = a.rltd_price_adj_id
24841: AND l.item_type_code = 'SERVICE' AND l.SUBSCRIPTION_ENABLE_FLAG <> 'Y'
24842: AND l.line_id = p_line_id AND prg.price_adjustment_id = a.price_adjustment_id
24843: AND prg.list_line_type_code = 'PRG'