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

Line 733: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

729: WHERE customer_trx_id = v_header_id;
730:
731: CURSOR SO_PICKING_HDR_INFO IS
732: SELECT A.organization_id, A.location_id
733: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
734: WHERE A.delivery_id = B.DELIVERY_ID AND
735: B.NAME = v_interface_line_attribute3 AND
736: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
737:

Line 755: JAI_OM_WSH_LINES_ALL

751: CURSOR c_ato_hdr_info IS
752: SELECT
753: organization_id, location_id
754: FROM
755: JAI_OM_WSH_LINES_ALL
756: WHERE
757: order_line_id IN (SELECT line_id
758: FROM oe_order_lines_all oel2
759: WHERE oel2.item_type_code = 'CONFIG'

Line 800: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b

796: preprinted_excise_inv_no, excise_invoice_date,
797: excise_exempt_type, excise_exempt_refno, excise_exempt_date
798: , ar3_form_no, ar3_form_date, -- Vijay Shankar for Bug # 3181892
799: vat_exemption_flag, vat_exemption_type, vat_exemption_date, vat_exemption_refno, vat_assessable_value, vat_invoice_no, vat_invoice_date -- added, Harshita for bug#4245062
800: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b
801: WHERE A.delivery_id = b.delivery_id AND
802: B.NAME = v_interface_line_attribute3 AND
803: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
804:

Line 866: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,

862: A.func_tax_amount,
863: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
864: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
865: b.vat_invoice_no,b.vat_invoice_date
866: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,
867: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D
868: WHERE A.delivery_detail_id = b.delivery_detail_id
869: AND A.tax_id=c.tax_id
870: and c.tax_type <> 'Modvat Recovery'/*Bug 4881426 bduvarag*/

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

876: CURSOR SO_PICKING_TAX_AMT(p_tax_id NUMBER) IS
877: SELECT SUM(A.base_tax_amount) base_tax_amount,
878: SUM(A.tax_amount) tax_amount,
879: SUM(A.func_tax_amount) func_tax_amount
880: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,WSH_NEW_DELIVERIES C
881: WHERE A.delivery_detail_id = b.delivery_detail_id
882: AND b.delivery_id = c.delivery_id
883: AND c.NAME = v_interface_line_attribute3
884: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6)

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

960: CURSOR ONCE_COMPLETE_FLAG_CUR IS
961: SELECT once_completed_flag
962: FROM JAI_AR_TRXS
963: WHERE customer_trx_id = v_header_id;
964: /* Cursor To Check Whether Interfaced Record Exist in JAI_OM_WSH_LINES_ALL */
965:
966: CURSOR SO_PICKING_RECORD_CHECK IS
967: SELECT 1
968: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

Line 968: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

964: /* Cursor To Check Whether Interfaced Record Exist in JAI_OM_WSH_LINES_ALL */
965:
966: CURSOR SO_PICKING_RECORD_CHECK IS
967: SELECT 1
968: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
969: WHERE A.delivery_id = B.DELIVERY_ID AND
970: B.NAME = v_interface_line_attribute3
971: AND A.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002
972:

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

989: AND A.customer_trx_id = b.customer_trx_id;
990:
991: CURSOR SO_PICKING_TAX_RECORD_CHECK IS
992: SELECT DISTINCT 1
993: FROM JAI_OM_WSH_LINE_TAXES A, JAI_OM_WSH_LINES_ALL b, WSH_NEW_DELIVERIES C
994: WHERE A.delivery_detail_id = b.delivery_detail_id
995: AND b.delivery_id = C.DELIVERY_ID AND
996: c.NAME = v_interface_line_attribute3
997: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002

Line 1118: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

1114: CURSOR get_header_info_cur IS
1115: SELECT A.organization_id,
1116: A.location_id,
1117: A.order_type_id
1118: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
1119: WHERE A.delivery_id = B.DELIVERY_ID AND
1120: B.NAME = v_interface_line_attribute3
1121: AND A.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002
1122:

Line 1288: v_ex_inv_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;

1284: v_so_line_id Number;
1285: v_item_type oe_order_lines_all.item_type_code%type;
1286: v_ato_line_id Varchar2(30);
1287: v_config_line_id Number;
1288: v_ex_inv_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;
1289: v_pmt_reg JAI_OM_WSH_LINES_ALL.register%type;
1290: v_pre_prnt_ex_no JAI_OM_WSH_LINES_ALL.preprinted_excise_inv_no%type;
1291: v_ato_line_amount Number;
1292: v_ato_tax_amount Number;

Line 1289: v_pmt_reg JAI_OM_WSH_LINES_ALL.register%type;

1285: v_item_type oe_order_lines_all.item_type_code%type;
1286: v_ato_line_id Varchar2(30);
1287: v_config_line_id Number;
1288: v_ex_inv_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;
1289: v_pmt_reg JAI_OM_WSH_LINES_ALL.register%type;
1290: v_pre_prnt_ex_no JAI_OM_WSH_LINES_ALL.preprinted_excise_inv_no%type;
1291: v_ato_line_amount Number;
1292: v_ato_tax_amount Number;
1293: v_ato_total_amount Number;

Line 1290: v_pre_prnt_ex_no JAI_OM_WSH_LINES_ALL.preprinted_excise_inv_no%type;

1286: v_ato_line_id Varchar2(30);
1287: v_config_line_id Number;
1288: v_ex_inv_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;
1289: v_pmt_reg JAI_OM_WSH_LINES_ALL.register%type;
1290: v_pre_prnt_ex_no JAI_OM_WSH_LINES_ALL.preprinted_excise_inv_no%type;
1291: v_ato_line_amount Number;
1292: v_ato_tax_amount Number;
1293: v_ato_total_amount Number;
1294: -- v_ar3_form_no Number;

Line 1377: FROM JAI_OM_WSH_LINES_ALL

1373: WHERE line_id = v_ato_line_id;
1374:
1375: cursor c_so_picking_data (v_ato_line_id Varchar2) is
1376: SELECT excise_invoice_no , register , preprinted_excise_inv_no , ar3_form_no ,ar3_form_date
1377: FROM JAI_OM_WSH_LINES_ALL
1378: WHERE order_line_id = v_ato_line_id;
1379:
1380: CURSOR so_ato_picking_hdr_info(v_ato_line_id Varchar2) IS
1381: SELECT a.organization_id, a.location_id

Line 1382: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b

1378: WHERE order_line_id = v_ato_line_id;
1379:
1380: CURSOR so_ato_picking_hdr_info(v_ato_line_id Varchar2) IS
1381: SELECT a.organization_id, a.location_id
1382: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b
1383: WHERE a.delivery_id = b.delivery_id and
1384: B.NAME = v_interface_line_attribute3 AND
1385: A.order_line_id = TO_NUMBER(v_ato_line_id);
1386:

Line 2535: from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL table.

2531: 20 2004/02/16 RBASKER - Bug 3357587, Version 618.2
2532: When SO UOM is different from that of the primary UOM,
2533: JAI_AR_TRX_LINES is updated with wrong assessable value
2534: Added a cursor C_JA_SO_LINES_ASSESSABLE_VAL to fetch the correct assessable_value
2535: from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL table.
2536:
2537: 21. 2004/05/05 ssumaith - bug# 3607101 - Version 619.1
2538: When autoinvoice import program imports an invoice from customer software and if interface_line_attribute11
2539: field in the ra_customer_trx_lines_all table is not null then , localization taxes are not retreived

Line 2575: and vat_assessable_value have been added in JAI_OM_OE_SO_LINES, JAI_OM_WSH_LINES_ALL

2571: bug# 4146708 creates the objects
2572:
2573: 26. 17-Mar-2005 hjujjuru - bug #4245062 File version 115.6
2574: The columns vat_exemption_flag, vat_exemption_type, vat_exemption_date, vat_exemption_refno,
2575: and vat_assessable_value have been added in JAI_OM_OE_SO_LINES, JAI_OM_WSH_LINES_ALL
2576: and JAI_AR_TRX_LINES.
2577: Additional fields vat_invoice_no and vat_invoice_date have been added into JAI_OM_WSH_LINES_ALL
2578: and JAI_AR_TRXS.
2579: The trigger has been updated to ensure that any data flowing into JAI_AR_TRX_LINES and

Line 2577: Additional fields vat_invoice_no and vat_invoice_date have been added into JAI_OM_WSH_LINES_ALL

2573: 26. 17-Mar-2005 hjujjuru - bug #4245062 File version 115.6
2574: The columns vat_exemption_flag, vat_exemption_type, vat_exemption_date, vat_exemption_refno,
2575: and vat_assessable_value have been added in JAI_OM_OE_SO_LINES, JAI_OM_WSH_LINES_ALL
2576: and JAI_AR_TRX_LINES.
2577: Additional fields vat_invoice_no and vat_invoice_date have been added into JAI_OM_WSH_LINES_ALL
2578: and JAI_AR_TRXS.
2579: The trigger has been updated to ensure that any data flowing into JAI_AR_TRX_LINES and
2580: JAI_AR_TRXS also includes the Vat information that comes down from either JAI_OM_OE_SO_LINES
2581: or JAI_OM_WSH_LINES_ALL .

Line 2581: or JAI_OM_WSH_LINES_ALL .

2577: Additional fields vat_invoice_no and vat_invoice_date have been added into JAI_OM_WSH_LINES_ALL
2578: and JAI_AR_TRXS.
2579: The trigger has been updated to ensure that any data flowing into JAI_AR_TRX_LINES and
2580: JAI_AR_TRXS also includes the Vat information that comes down from either JAI_OM_OE_SO_LINES
2581: or JAI_OM_WSH_LINES_ALL .
2582:
2583: Base bug - #4245089
2584:
2585: Trigger file name is renamed to JAI_AR_RCTLA_T7.SQL

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

3534: process_bill_only_invoice;
3535: return;
3536: end if;
3537: -- here code returns for an ato imported order because because
3538: -- records do not exist in JAI_OM_WSH_LINES_ALL table
3539: process_taxes_for_ato_order;
3540:
3541:
3542: END IF;

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

3820: IF v_register_code = 'BOND_REG' THEN
3821: v_tax_amount := v_bond_tax_amt / v_qty;
3822: END IF;
3823: -- Bug 3357587
3824: -- To pick assessable_value from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL
3825: OPEN C_JA_SO_LINES_ASSESSABLE_VAL;
3826: FETCH C_JA_SO_LINES_ASSESSABLE_VAL into v_assessable_value,v_service_type;/*5879769..csahoo*/
3827: CLOSE C_JA_SO_LINES_ASSESSABLE_VAL;
3828:

Line 4237: FROM JAI_OM_WSH_LINES_ALL

4233:
4234: -- following cursor definition modified by sriram - bug # 2755890 - 18/01/2003
4235: CURSOR SO_RMA_HDR_INFO IS
4236: SELECT organization_id, location_id
4237: FROM JAI_OM_WSH_LINES_ALL
4238: WHERE order_line_id IN
4239: (SELECT reference_line_id
4240: FROM oe_order_lines_all
4241: WHERE to_char(line_id) = v_interface_line_attribute7

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

4289: FROM JAI_AR_TRXS
4290: WHERE customer_trx_id = v_header_id;
4291:
4292:
4293: /* Cursor To Check Whether Interfaced Record Exist in JAI_OM_WSH_LINES_ALL */
4294: CURSOR SO_RMA_RECORD_CHECK IS
4295: SELECT 1
4296: FROM JAI_OM_OE_RMA_LINES
4297: WHERE rma_line_id = v_interface_line_attribute7;