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.JAI_CREDIT_CHECK_PKG dependencies on OE_ORDER_LINES

Line 118: -- Cursor used to get JAI line tax amount and OE_ORDER_LINES tax amount by given header id

114: ---------------------------------------------------------------------------------------------------------------------------------*/
115: FUNCTION check_tax_amount_difference (pn_so_order_id IN NUMBER)
116: RETURN VARCHAR2
117: IS
118: -- Cursor used to get JAI line tax amount and OE_ORDER_LINES tax amount by given header id
119: CURSOR get_sum_tax_cur
120: IS
121: SELECT LINES_ALL.LINE_ID
122: ,LINES_ALL.ORDER_LINE_TAX_VALUE

Line 128: FROM OE_ORDER_LINES LINE

124: FROM
125: (SELECT LINE.LINE_ID LINE_ID
126: ,NVL(LINE.TAX_VALUE,0) ORDER_LINE_TAX_VALUE
127: ,TAX.TAX_AMOUNT JAI_TAX_LINE_AMOUNT
128: FROM OE_ORDER_LINES LINE
129: ,JAI_OM_OE_SO_TAXES TAX
130: ,JAI_CMN_TAXES_ALL JCTA
131: WHERE LINE.HEADER_ID = pn_so_order_id
132: AND TAX.LINE_ID = LINE.LINE_ID

Line 139: FROM OE_ORDER_LINES LINE

135: UNION ALL
136: SELECT LINE.LINE_ID LINE_ID
137: ,NVL(LINE.TAX_VALUE,0) ORDER_LINE_TAX_VALUE
138: ,TAX.TAX_AMOUNT JAI_TAX_LINE_AMOUNT
139: FROM OE_ORDER_LINES LINE
140: ,JAI_OM_OE_RMA_TAXES TAX
141: ,JAI_CMN_TAXES_ALL JCTA
142: WHERE LINE.HEADER_ID = pn_so_order_id
143: AND TAX.RMA_LINE_ID = LINE.LINE_ID

Line 189: FROM OE_ORDER_LINES LINE,

185: SELECT TAX_AMOUNT_SUM
186: FROM
187: ( SELECT LINE.LINE_ID,
188: NVL(SUM(TAX.TAX_AMOUNT), 0) TAX_AMOUNT_SUM
189: FROM OE_ORDER_LINES LINE,
190: JAI_OM_OE_SO_TAXES TAX,
191: JAI_CMN_TAXES_ALL JCTA
192: WHERE LINE.LINE_ID = pn_line_id
193: AND TAX.LINE_ID = LINE.LINE_ID

Line 200: FROM OE_ORDER_LINES LINE,

196: GROUP BY LINE.LINE_ID
197: UNION ALL
198: SELECT LINE.LINE_ID,
199: NVL(SUM(TAX.TAX_AMOUNT), 0) TAX_AMOUNT_SUM
200: FROM OE_ORDER_LINES LINE,
201: JAI_OM_OE_RMA_TAXES TAX,
202: JAI_CMN_TAXES_ALL JCTA
203: WHERE LINE.LINE_ID = pn_line_id
204: AND TAX.RMA_LINE_ID = LINE.LINE_ID

Line 283: CURSOR get_order_lines_cur(pn_header_id OE_ORDER_LINES.HEADER_ID%TYPE)

279: WHERE OH.HEADER_ID = pn_so_header_id
280: FOR UPDATE;
281:
282: -- Cursor used to get the details of open order lines by header id.
283: CURSOR get_order_lines_cur(pn_header_id OE_ORDER_LINES.HEADER_ID%TYPE)
284: IS
285: SELECT
286: OL.LINE_ID line_id
287: ,OL.LINE_CATEGORY_CODE LINE_CATEGORY_CODE

Line 290: FROM OE_ORDER_LINES OL,

286: OL.LINE_ID line_id
287: ,OL.LINE_CATEGORY_CODE LINE_CATEGORY_CODE
288: ,JL.LINE_NUMBER LINE_NUMBER
289: ,NVL(OL.TAX_VALUE,0) TAX_VALUE
290: FROM OE_ORDER_LINES OL,
291: JAI_OM_OE_SO_LINES JL
292: WHERE OL.HEADER_ID = pn_header_id
293: AND OL.HEADER_ID = JL.HEADER_ID
294: AND OL.LINE_ID = JL.LINE_ID

Line 304: FROM OE_ORDER_LINES OL,

300: OL.LINE_ID line_id
301: ,OL.LINE_CATEGORY_CODE LINE_CATEGORY_CODE
302: ,JL.RMA_LINE_NUMBER LINE_NUMBER
303: ,NVL(OL.TAX_VALUE,0) TAX_VALUE
304: FROM OE_ORDER_LINES OL,
305: JAI_OM_OE_RMA_LINES JL
306: WHERE OL.HEADER_ID = pn_header_id
307: AND OL.HEADER_ID = JL.RMA_HEADER_ID
308: AND OL.LINE_ID = JL.RMA_LINE_ID

Line 507: ,OE_ORDER_LINES LINE

503: ,TAX.TAX_ID TAX_ID
504: ,TAX.TAX_AMOUNT TAX_AMOUNT
505: ,TAX.TAX_RATE TAX_RATE
506: FROM OE_ORDER_HEADERS HDR
507: ,OE_ORDER_LINES LINE
508: ,JAI_OM_OE_SO_TAXES TAX
509: ,JAI_CMN_TAXES_ALL JCTA
510: WHERE HDR.HEADER_ID = LINE.HEADER_ID
511: AND TAX.LINE_ID = LINE.LINE_ID

Line 533: ,OE_ORDER_LINES LINE

529: ,TAX.TAX_ID TAX_ID
530: ,TAX.TAX_AMOUNT TAX_AMOUNT
531: ,TAX.TAX_RATE TAX_RATE
532: FROM OE_ORDER_HEADERS HDR
533: ,OE_ORDER_LINES LINE
534: ,JAI_OM_OE_RMA_TAXES TAX
535: ,JAI_CMN_TAXES_ALL JCTA
536: WHERE HDR.HEADER_ID = LINE.HEADER_ID
537: AND TAX.RMA_LINE_ID = LINE.LINE_ID

Line 549: lv_line_type OE_ORDER_LINES.LINE_CATEGORY_CODE%type;

545:
546: --Variable Block
547: ln_line_exclusive_tax_amt NUMBER := 0;
548: lv_object_name VARCHAR2(200) := 'jai_credit_check.process_order';
549: lv_line_type OE_ORDER_LINES.LINE_CATEGORY_CODE%type;
550:
551: BEGIN
552: xv_return_code := jai_constants.successful ;
553: -- delete records

Line 656: UPDATE OE_ORDER_LINES

652:
653: END IF;
654:
655: --Update tax value with exclusive tax summary.
656: UPDATE OE_ORDER_LINES
657: SET tax_value = ln_line_exclusive_tax_amt
658: WHERE header_id = pn_header_id
659: AND line_id = pn_line_id;
660: fnd_file.put_line(FND_FILE.LOG,'Updated oe_order_lines.'||'Header:'||pn_header_id||',line:'||pn_line_id||',tax value:'||ln_line_exclusive_tax_amt);

Line 660: fnd_file.put_line(FND_FILE.LOG,'Updated oe_order_lines.'||'Header:'||pn_header_id||',line:'||pn_line_id||',tax value:'||ln_line_exclusive_tax_amt);

656: UPDATE OE_ORDER_LINES
657: SET tax_value = ln_line_exclusive_tax_amt
658: WHERE header_id = pn_header_id
659: AND line_id = pn_line_id;
660: fnd_file.put_line(FND_FILE.LOG,'Updated oe_order_lines.'||'Header:'||pn_header_id||',line:'||pn_line_id||',tax value:'||ln_line_exclusive_tax_amt);
661:
662: EXCEPTION
663: WHEN OTHERS THEN
664: xv_return_code := jai_constants.unexpected_error;

Line 715: OE_ORDER_LINES ol

711: SELECT COUNT(wdd.delivery_detail_id)
712: INTO ln_count
713: FROM wsh_delivery_details wdd,
714: OE_ORDER_HEADERS oh,
715: OE_ORDER_LINES ol
716: WHERE wdd.source_header_number = oh.ORDER_NUMBER
717: AND wdd.source_header_id = oh.header_id
718: AND oh.header_id = ol.header_id
719: AND ol.line_id = pn_so_line_id