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_ADV_PRICE_PVT dependencies on OE_PRICE_ADJUSTMENTS

Line 320: FROM OE_PRICE_ADJUSTMENTS adj

316: --amy: revert to original item if the IUE is deleted
317: Cursor revert_back_items IS
318: SELECT adj.line_id, adj.modified_from,adj.price_adjustment_id
319: ,adj.modifier_level_code --Bug 13573144
320: FROM OE_PRICE_ADJUSTMENTS adj
321: WHERE HEADER_ID = oe_order_cache.g_header_rec.header_id
322: AND list_line_Type_code = 'IUE'
323: AND PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
324: where instr(p_pricing_events||',', pricing_event_code||',') >0)

Line 378: DELETE FROM OE_PRICE_ADJUSTMENTS

374: px_line_tbl(G_PRICE_LINE_ID_TBL(l_mod_line_id)).change_reason := 'SYSTEM';
375: px_line_tbl(G_PRICE_LINE_ID_TBL(l_mod_line_id)).change_comments := 'REPRICING';
376:
377: --bug 2858712
378: DELETE FROM OE_PRICE_ADJUSTMENTS
379: WHERE PRICE_ADJUSTMENT_ID = i.price_adjustment_id;
380: --Bug 13573144
381: if i.modifier_level_code = 'ORDER' then
382: delete_attribs_for_iue(i.price_adjustment_id,i.modifier_level_code);

Line 412: INSERT INTO OE_PRICE_ADJUSTMENTS

408: --bug 2795409
409: px_line_tbl(G_PRICE_LINE_ID_TBL(l_mod_line_id)).change_reason := 'SYSTEM';
410: px_line_tbl(G_PRICE_LINE_ID_TBL(l_mod_line_id)).change_comments := 'REPRICING';
411:
412: INSERT INTO OE_PRICE_ADJUSTMENTS
413: ( PRICE_ADJUSTMENT_ID
414: , CREATION_DATE
415: , CREATED_BY
416: , LAST_UPDATE_DATE

Line 515: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id

511: , ADJUSTED_AMOUNT_PER_PQTY
512: , LOCK_CONTROL
513: )
514: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
515: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
516: ldets.price_adjustment_id
517: , sysdate --p_Line_Adj_rec.creation_date
518: , fnd_global.user_id --p_Line_Adj_rec.created_by
519: , sysdate --p_Line_Adj_rec.last_update_date

Line 649: from oe_price_adjustments where

645: Is
646: cursor oe_price_adj_cur(p_line_id number) is
647: select price_adjustment_id,LIST_LINE_ID,PRICING_PHASE_ID ,
648: MODIFIER_LEVEL_CODE
649: from oe_price_adjustments where
650: line_id = p_line_id and LIST_LINE_TYPE_CODE = 'TSN';
651:
652: Cursor ldets_cur is
653: select line_index,LINE_DETAIL_INDEX,LINE_DETAIL_TYPE_CODE,

Line 685: FROM OE_PRICE_ADJUSTMENTS adj

681: Cursor revert_back_tsn_line IS
682: SELECT adj.line_id, adj.modified_from,adj.price_adjustment_id,
683: adj.SUBSTITUTION_ATTRIBUTE, adj.MODIFIER_LEVEL_CODE,
684: adj.header_id
685: FROM OE_PRICE_ADJUSTMENTS adj
686: WHERE adj.HEADER_ID = oe_order_cache.g_header_rec.header_id
687: AND adj.list_line_Type_code = 'TSN'
688: AND adj.PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
689: where instr(p_pricing_events||',', pricing_event_code||',')>0)

Line 706: FROM OE_PRICE_ADJUSTMENTS adj

702: Cursor revert_back_tsn_order IS
703: SELECT adj.line_id, adj.modified_from,adj.price_adjustment_id,
704: adj.SUBSTITUTION_ATTRIBUTE, adj.MODIFIER_LEVEL_CODE,
705: adj.header_id
706: FROM OE_PRICE_ADJUSTMENTS adj
707: WHERE adj.HEADER_ID = oe_order_cache.g_header_rec.header_id
708: AND adj.list_line_Type_code = 'TSN'
709: AND adj.PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
710: where instr(p_pricing_events||',', pricing_event_code||',')>0)

Line 726: from oe_price_Adjustments

722: and l.line_type_code='ORDER' and l.line_id = adj.header_id);
723:
724: Cursor order_level_Adj(p_header_id in Number) IS
725: select substitution_attribute, modified_to
726: from oe_price_Adjustments
727: where header_id = p_header_id and line_id is null
728: and list_line_type_code = 'TSN';
729: --End of Bug 13573144
730: i number;

Line 829: select count(*) into vcount from oe_price_adjustments where

825: oe_debug_pub.add( 'LINE ID = '||PX_LINE_TBL ( J ) .LINE_ID ,1 ) ;
826: END IF;
827: --update line only if open and not cancelled
828: if( nvl(px_line_tbl(j).cancelled_flag,'N') <> 'Y' and nvl(px_line_tbl(j).open_flag,'Y') <> 'N' ) THEN
829: select count(*) into vcount from oe_price_adjustments where
830: line_id = px_line_tbl(j).line_id and
831: LIST_LINE_TYPE_CODE = 'TSN' and MODIFIER_LEVEL_CODE = 'LINE';
832: If vcount = 0 then
833: If i.Substitution_Attribute ='QUALIFIER_ATTRIBUTE1' Then

Line 852: DELETE FROM OE_PRICE_ADJUSTMENTS

848: oe_debug_pub.add( 'J = END OF LOOP '||J , 1 ) ;
849: END IF;
850: END LOOP;
851:
852: DELETE FROM OE_PRICE_ADJUSTMENTS
853: WHERE PRICE_ADJUSTMENT_ID = i.price_adjustment_id;
854: if i.MODIFIER_LEVEL_CODE = 'ORDER' then
855: delete_attribs_for_iue(i.price_adjustment_id,i.MODIFIER_LEVEL_CODE);
856: else

Line 913: DELETE FROM OE_PRICE_ADJUSTMENTS

909: set_tsn(px_line_tbl(G_PRICE_LINE_ID_TBL(l_mod_line_id)),l_mod_to, i.substitution_attribute);
910: px_line_tbl(G_PRICE_LINE_ID_TBL(l_mod_line_id)).operation := OE_GLOBALS.G_OPR_UPDATE;
911: px_line_tbl(G_PRICE_LINE_ID_TBL(l_mod_line_id)).change_reason := 'SYSTEM';
912: px_line_tbl(G_PRICE_LINE_ID_TBL(l_mod_line_id)).change_comments := 'REPRICING';
913: DELETE FROM OE_PRICE_ADJUSTMENTS
914: WHERE PRICE_ADJUSTMENT_ID = i.price_adjustment_id;
915: delete_attribs_for_iue(i.price_adjustment_id);
916: END LOOP;
917: --End of Bug 13573144

Line 990: select count(*) into vcount from oe_price_adjustments where

986: if( nvl(px_line_tbl(j).cancelled_flag,'N') <> 'Y' and nvl(px_line_tbl(j).open_flag,'Y') <> 'N' ) THEN
987: if (l_debug_level > 0) then
988: oe_debug_pub.add( 'Lalit As the line in not closed/cancelled updating LINE ID = '||PX_LINE_TBL ( J ) .LINE_ID , 1 ) ;
989: end if;
990: select count(*) into vcount from oe_price_adjustments where
991: line_id = px_line_tbl(j).line_id and
992: LIST_LINE_TYPE_CODE = 'TSN' and MODIFIER_LEVEL_CODE = 'LINE';
993: If vcount = 0 then
994: If i.Substitution_Attribute ='QUALIFIER_ATTRIBUTE1' Then

Line 1046: INSERT INTO OE_PRICE_ADJUSTMENTS

1042: px_line_tbl(G_PRICE_LINE_ID_TBL(l_mod_line_id)).change_reason := 'SYSTEM';
1043: px_line_tbl(G_PRICE_LINE_ID_TBL(l_mod_line_id)).change_comments := 'REPRICING';
1044: End If;
1045: --bug 4190357
1046: INSERT INTO OE_PRICE_ADJUSTMENTS
1047: ( PRICE_ADJUSTMENT_ID
1048: , CREATION_DATE
1049: , CREATED_BY
1050: , LAST_UPDATE_DATE

Line 1149: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id

1145: , ADJUSTED_AMOUNT_PER_PQTY
1146: , LOCK_CONTROL
1147: )
1148: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
1149: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
1150: ldets.price_adjustment_id
1151: , sysdate --p_Line_Adj_rec.creation_date
1152: , fnd_global.user_id --p_Line_Adj_rec.created_by
1153: , sysdate --p_Line_Adj_rec.last_update_date

Line 2678: INSERT INTO OE_PRICE_ADJUSTMENTS

2674: BEGIN
2675: IF l_debug_level > 0 THEN
2676: oe_debug_pub.add( 'INSIDE OE_ADV_PRICE_PVT.INSERT_ADJ' ) ;
2677: END IF;
2678: INSERT INTO OE_PRICE_ADJUSTMENTS
2679: ( PRICE_ADJUSTMENT_ID
2680: , CREATION_DATE
2681: , CREATED_BY
2682: , LAST_UPDATE_DATE

Line 2781: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id

2777: , ADJUSTED_AMOUNT_PER_PQTY
2778: , LOCK_CONTROL
2779: )
2780: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
2781: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2782: ldets.price_adjustment_id
2783: , sysdate --p_Line_Adj_rec.creation_date
2784: , fnd_global.user_id --p_Line_Adj_rec.created_by
2785: , sysdate --p_Line_Adj_rec.last_update_date

Line 2815: , 'OE_PRICE_ADJUSTMENTS'||ldets.price_adjustment_id --p_Line_Adj_rec.orig_sys_discount_ref

2811: , NULL --p_Line_Adj_rec.attribute13
2812: , NULL --p_Line_Adj_rec.attribute14
2813: , NULL --p_Line_Adj_rec.attribute15
2814: -- Bug 7523118
2815: , 'OE_PRICE_ADJUSTMENTS'||ldets.price_adjustment_id --p_Line_Adj_rec.orig_sys_discount_ref
2816: , ldets.LIST_HEADER_ID
2817: , ldets.LIST_LINE_ID
2818: , ldets.LIST_LINE_TYPE_CODE
2819: , NULL --p_Line_Adj_rec.MODIFIER_MECHANISM_TYPE_CODE

Line 2907: FROM OE_PRICE_ADJUSTMENTS

2903: -- AND (p_line_id is null or (p_line_id is not null and lines.line_id = p_line_id and lines.line_type_code = 'LINE'))
2904: -- AND (l_booked_flag = 'N' or ldets.list_line_type_code<>'IUE')
2905: AND LDETS.PRICE_ADJUSTMENT_ID NOT IN (
2906: SELECT PRICE_ADJUSTMENT_ID
2907: FROM OE_PRICE_ADJUSTMENTS
2908: WHERE PRICE_ADJUSTMENT_ID = LDETS.PRICE_ADJUSTMENT_ID
2909: ) --Bug#10193597
2910: );
2911: