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_AR_IMPORT_POPU_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 32: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

28: v_header_id number;
29: v_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;
30: CURSOR SO_PICKING_RECORD_CHECK IS
31: SELECT 1
32: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
33: WHERE A.delivery_id = B.DELIVERY_ID AND
34: B.NAME = v_interface_line_attribute3
35: AND A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
36:

Line 99: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

95: t_rec_old jai_ar_trxs%rowtype;
96:
97: CURSOR SO_PICKING_HDR_INFO IS
98: SELECT A.organization_id, A.location_id
99: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
100: WHERE A.delivery_id = B.DELIVERY_ID AND
101: B.NAME = v_interface_line_attribute3 AND
102: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
103:

Line 106: FROM JAI_OM_WSH_LINES_ALL a

102: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
103:
104: CURSOR so_picking_hdr_info_1 IS
105: SELECT a.organization_id, a.location_id
106: FROM JAI_OM_WSH_LINES_ALL a
107: WHERE a.delivery_id = v_interface_line_attribute3
108: AND a.organization_id IS NOT NULL
109: AND a.location_id IS NOT NULL
110: AND rownum=1 ;

Line 134: JAI_OM_WSH_LINES_ALL

130: CURSOR c_ato_hdr_info IS
131: SELECT
132: organization_id, location_id
133: FROM
134: JAI_OM_WSH_LINES_ALL
135: WHERE
136: order_line_id IN (SELECT line_id
137: FROM oe_order_lines_all oel2
138: WHERE oel2.item_type_code = 'CONFIG'

Line 156: FROM JAI_OM_WSH_LINES_ALL jowla

152: CURSOR c_so_picking_hdr_info_ns
153: IS
154: SELECT jowla.organization_id
155: , jowla.location_id
156: FROM JAI_OM_WSH_LINES_ALL jowla
157: WHERE order_line_id = TO_NUMBER(v_interface_line_attribute6)
158: AND shippable_flag = 'N';
159:
160: CURSOR c_so_picking_tax_record_ns

Line 192: , JAI_OM_WSH_LINES_ALL jowla

188: , jowlt.precedence_10
189: , jowla.vat_invoice_no
190: , jowla.vat_invoice_date
191: FROM JAI_OM_WSH_LINE_TAXES jowlt
192: , JAI_OM_WSH_LINES_ALL jowla
193: , JAI_CMN_TAXES_ALL jcta
194: WHERE jowlt.delivery_detail_id IS NULL
195: AND jowlt.order_line_id = jowla.order_line_id
196: AND jowlt.tax_id= jcta.tax_id

Line 213: FROM JAI_OM_WSH_LINE_TAXES A, JAI_OM_WSH_LINES_ALL b, WSH_NEW_DELIVERIES C

209: WHERE customer_trx_id = pr_new.customer_trx_id;
210:
211: CURSOR SO_PICKING_TAX_RECORD_CHECK IS
212: SELECT DISTINCT 1
213: FROM JAI_OM_WSH_LINE_TAXES A, JAI_OM_WSH_LINES_ALL b, WSH_NEW_DELIVERIES C
214: WHERE A.delivery_detail_id = b.delivery_detail_id
215: AND b.delivery_id = C.DELIVERY_ID AND
216: c.NAME = v_interface_line_attribute3
217: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002

Line 233: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,

229: A.func_tax_amount,
230: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
231: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
232: b.vat_invoice_no,b.vat_invoice_date
233: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,
234: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D
235: WHERE A.delivery_detail_id = b.delivery_detail_id
236: AND A.tax_id=c.tax_id
237: and c.tax_type <> 'Modvat Recovery'

Line 246: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,WSH_NEW_DELIVERIES C

242: CURSOR SO_PICKING_TAX_AMT(p_tax_id NUMBER) IS
243: SELECT SUM(A.base_tax_amount) base_tax_amount,
244: SUM(A.tax_amount) tax_amount,
245: SUM(A.func_tax_amount) func_tax_amount
246: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,WSH_NEW_DELIVERIES C
247: WHERE A.delivery_detail_id = b.delivery_detail_id
248: AND b.delivery_id = c.delivery_id
249: AND c.NAME = v_interface_line_attribute3
250: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6)

Line 272: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b

268: preprinted_excise_inv_no, excise_invoice_date,
269: excise_exempt_type, excise_exempt_refno, excise_exempt_date
270: , ar3_form_no, ar3_form_date,
271: vat_exemption_flag, vat_exemption_type, vat_exemption_date, vat_exemption_refno, vat_assessable_value, vat_invoice_no, vat_invoice_date
272: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b
273: WHERE A.delivery_id = b.delivery_id AND
274: B.NAME = v_interface_line_attribute3 AND
275: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
276:

Line 317: FROM JAI_OM_WSH_LINES_ALL

313: , vat_exemption_refno
314: , vat_assessable_value
315: , vat_invoice_no
316: , vat_invoice_date
317: FROM JAI_OM_WSH_LINES_ALL
318: WHERE delivery_id IS NULL
319: AND order_line_id = TO_NUMBER(v_interface_line_attribute6);
320:
321: CURSOR JA_SO_LINES_TAX_RECORD_CHECK IS

Line 416: v_ex_inv_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;

412: v_excise_amount NUMBER;
413: v_once_completed_flag VARCHAR2(1);
414: v_line_amount NUMBER;
415: v_config_line_id Number;
416: v_ex_inv_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;
417: v_pmt_reg JAI_OM_WSH_LINES_ALL.register%type;
418: v_pre_prnt_ex_no JAI_OM_WSH_LINES_ALL.preprinted_excise_inv_no%type;
419: v_ato_tax_amount Number;
420: v_ato_line_amount Number;

Line 417: v_pmt_reg JAI_OM_WSH_LINES_ALL.register%type;

413: v_once_completed_flag VARCHAR2(1);
414: v_line_amount NUMBER;
415: v_config_line_id Number;
416: v_ex_inv_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;
417: v_pmt_reg JAI_OM_WSH_LINES_ALL.register%type;
418: v_pre_prnt_ex_no JAI_OM_WSH_LINES_ALL.preprinted_excise_inv_no%type;
419: v_ato_tax_amount Number;
420: v_ato_line_amount Number;
421: v_ato_total_amount Number;

Line 418: v_pre_prnt_ex_no JAI_OM_WSH_LINES_ALL.preprinted_excise_inv_no%type;

414: v_line_amount NUMBER;
415: v_config_line_id Number;
416: v_ex_inv_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;
417: v_pmt_reg JAI_OM_WSH_LINES_ALL.register%type;
418: v_pre_prnt_ex_no JAI_OM_WSH_LINES_ALL.preprinted_excise_inv_no%type;
419: v_ato_tax_amount Number;
420: v_ato_line_amount Number;
421: v_ato_total_amount Number;
422:

Line 490: FROM JAI_OM_WSH_LINES_ALL

486:
487:
488: CURSOR c_get_vat_inv_no IS
489: SELECT VAT_INVOICE_NO
490: FROM JAI_OM_WSH_LINES_ALL
491: WHERE DELIVERY_ID IS NULL
492: AND ORDER_LINE_ID = TO_NUMBER(v_interface_line_attribute6);
493:
494: lv_vat_invoice_no JAI_OM_WSH_LINES_ALL.VAT_INVOICE_NO%TYPE;

Line 494: lv_vat_invoice_no JAI_OM_WSH_LINES_ALL.VAT_INVOICE_NO%TYPE;

490: FROM JAI_OM_WSH_LINES_ALL
491: WHERE DELIVERY_ID IS NULL
492: AND ORDER_LINE_ID = TO_NUMBER(v_interface_line_attribute6);
493:
494: lv_vat_invoice_no JAI_OM_WSH_LINES_ALL.VAT_INVOICE_NO%TYPE;
495:
496:
497:
498: lr_trx_rec c_trx_cur%rowtype;

Line 1238: FROM JAI_OM_WSH_LINES_ALL

1234: WHERE line_id = v_ato_line_id;
1235:
1236: cursor c_so_picking_data (v_ato_line_id Varchar2) is
1237: SELECT excise_invoice_no , register , preprinted_excise_inv_no , ar3_form_no ,ar3_form_date
1238: FROM JAI_OM_WSH_LINES_ALL
1239: WHERE order_line_id = v_ato_line_id;
1240:
1241: CURSOR so_ato_picking_hdr_info(v_ato_line_id Varchar2) IS
1242: SELECT a.organization_id, a.location_id

Line 1243: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b

1239: WHERE order_line_id = v_ato_line_id;
1240:
1241: CURSOR so_ato_picking_hdr_info(v_ato_line_id Varchar2) IS
1242: SELECT a.organization_id, a.location_id
1243: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b
1244: WHERE a.delivery_id = b.delivery_id and
1245: B.NAME = v_interface_line_attribute3 AND
1246: A.order_line_id = TO_NUMBER(v_ato_line_id);
1247:

Line 1951: -- records do not exist in JAI_OM_WSH_LINES_ALL table

1947: process_bill_only_invoice;
1948: return;
1949: end if;
1950: -- here code returns for an ato imported order because because
1951: -- records do not exist in JAI_OM_WSH_LINES_ALL table
1952: process_taxes_for_ato_order;
1953:
1954:
1955: END IF;

Line 2293: -- To pick assessable_value from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL

2289: IF v_register_code = 'BOND_REG' THEN
2290: v_tax_amount := v_bond_tax_amt / v_qty;
2291: END IF;
2292:
2293: -- To pick assessable_value from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL
2294: OPEN C_JA_SO_LINES_ASSESSABLE_VAL;
2295: FETCH C_JA_SO_LINES_ASSESSABLE_VAL into v_assessable_value,v_service_type;
2296: CLOSE C_JA_SO_LINES_ASSESSABLE_VAL;
2297:

Line 2507: -- To pick assessable_value from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL

2503:
2504: IF v_register_code = 'BOND_REG' THEN
2505: v_tax_amount := v_bond_tax_amt / v_qty;
2506: END IF;
2507: -- To pick assessable_value from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL
2508: OPEN C_JA_SO_LINES_ASSESSABLE_VAL;
2509: FETCH C_JA_SO_LINES_ASSESSABLE_VAL into v_assessable_value,v_service_type;
2510: CLOSE C_JA_SO_LINES_ASSESSABLE_VAL;
2511: END IF; -- NVL(v_exist_flag,0) = 1

Line 4363: FROM JAI_OM_WSH_LINES_ALL a

4359: WHERE customer_trx_id = v_header_id;
4360:
4361: CURSOR so_picking_hdr_info_1 IS
4362: SELECT a.organization_id, a.location_id
4363: FROM JAI_OM_WSH_LINES_ALL a
4364: WHERE a.delivery_id = v_interface_line_attribute3
4365: AND a.organization_id IS NOT NULL
4366: AND a.location_id IS NOT NULL
4367: AND rownum=1 ;

Line 4413: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

4409: CURSOR get_header_info_cur IS
4410: SELECT A.organization_id,
4411: A.location_id,
4412: A.order_type_id
4413: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
4414: WHERE A.delivery_id = B.DELIVERY_ID AND
4415: B.NAME = v_interface_line_attribute3 AND
4416: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
4417:

Line 4850: FROM JAI_OM_WSH_LINES_ALL

4846:
4847:
4848: CURSOR SO_RMA_HDR_INFO IS
4849: SELECT organization_id, location_id
4850: FROM JAI_OM_WSH_LINES_ALL
4851: WHERE order_line_id IN
4852: (SELECT reference_line_id
4853: FROM oe_order_lines_all
4854: WHERE line_id = v_interface_line_attribute7

Line 4895: /* Cursor To Check Whether Interfaced Record Exist in JAI_OM_WSH_LINES_ALL */

4891: FROM JAI_AR_TRXS
4892: WHERE customer_trx_id = v_header_id;
4893:
4894:
4895: /* Cursor To Check Whether Interfaced Record Exist in JAI_OM_WSH_LINES_ALL */
4896: CURSOR SO_RMA_RECORD_CHECK IS
4897: SELECT 1
4898: FROM JAI_OM_OE_RMA_LINES
4899: WHERE rma_line_id = v_interface_line_attribute7;