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 772: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

768: WHERE customer_trx_id = v_header_id;
769:
770: CURSOR SO_PICKING_HDR_INFO IS
771: SELECT A.organization_id, A.location_id
772: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
773: WHERE A.delivery_id = B.DELIVERY_ID AND
774: B.NAME = v_interface_line_attribute3 AND
775: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
776:

Line 780: FROM JAI_OM_WSH_LINES_ALL a

776:
777: /* Added by JMEENA for bug#5684033 */
778: CURSOR so_picking_hdr_info_1 IS
779: SELECT a.organization_id, a.location_id
780: FROM JAI_OM_WSH_LINES_ALL a
781: WHERE a.delivery_id = v_interface_line_attribute3
782: AND a.organization_id IS NOT NULL
783: AND a.location_id IS NOT NULL
784: AND rownum=1 ;

Line 789: FROM JAI_OM_WSH_LINES_ALL a

785:
786: /*Added by Qinglei for bug$13405359*/
787: CURSOR so_non_ship_picking_info IS
788: SELECT a.organization_id, a.location_id
789: FROM JAI_OM_WSH_LINES_ALL a
790: WHERE order_line_id = v_interface_line_attribute6
791: AND a.organization_id IS NOT NULL
792: AND a.location_id IS NOT NULL;
793:

Line 811: JAI_OM_WSH_LINES_ALL

807: CURSOR c_ato_hdr_info IS
808: SELECT
809: organization_id, location_id
810: FROM
811: JAI_OM_WSH_LINES_ALL
812: WHERE
813: order_line_id IN (SELECT line_id
814: FROM oe_order_lines_all oel2
815: WHERE oel2.item_type_code = 'CONFIG'

Line 866: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b

862: , gst_invoice_date
863: ----------------------------------
864: --Added by Bo Li for bug#10091373 End
865: */
866: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b
867: WHERE A.delivery_id = b.delivery_id AND
868: B.NAME = v_interface_line_attribute3 AND
869: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
870:

Line 934: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,

930: A.func_tax_amount,
931: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
932: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
933: b.vat_invoice_no,b.vat_invoice_date
934: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,
935: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D
936: WHERE A.delivery_detail_id = b.delivery_detail_id
937: AND A.tax_id=c.tax_id
938: and c.tax_type <> 'Modvat Recovery'/*Bug 4881426 bduvarag*/

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

944: CURSOR SO_PICKING_TAX_AMT(p_tax_id NUMBER) IS
945: SELECT SUM(A.base_tax_amount) base_tax_amount,
946: SUM(A.tax_amount) tax_amount,
947: SUM(A.func_tax_amount) func_tax_amount
948: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,WSH_NEW_DELIVERIES C
949: WHERE A.delivery_detail_id = b.delivery_detail_id
950: AND b.delivery_id = c.delivery_id
951: -- AND c.NAME = v_interface_line_attribute3 -- commented for bug 14459402
952: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6)

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

1028: CURSOR ONCE_COMPLETE_FLAG_CUR IS
1029: SELECT once_completed_flag
1030: FROM JAI_AR_TRXS
1031: WHERE customer_trx_id = v_header_id;
1032: /* Cursor To Check Whether Interfaced Record Exist in JAI_OM_WSH_LINES_ALL */
1033:
1034: CURSOR SO_PICKING_RECORD_CHECK IS
1035: SELECT 1
1036: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

Line 1036: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

1032: /* Cursor To Check Whether Interfaced Record Exist in JAI_OM_WSH_LINES_ALL */
1033:
1034: CURSOR SO_PICKING_RECORD_CHECK IS
1035: SELECT 1
1036: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
1037: WHERE A.delivery_id = B.DELIVERY_ID AND
1038: B.NAME = v_interface_line_attribute3
1039: AND A.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002
1040:

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

1057: AND A.customer_trx_id = b.customer_trx_id;
1058:
1059: CURSOR SO_PICKING_TAX_RECORD_CHECK IS
1060: SELECT DISTINCT 1
1061: FROM JAI_OM_WSH_LINE_TAXES A, JAI_OM_WSH_LINES_ALL b, WSH_NEW_DELIVERIES C
1062: WHERE A.delivery_detail_id = b.delivery_detail_id
1063: AND b.delivery_id = C.DELIVERY_ID AND
1064: c.NAME = v_interface_line_attribute3
1065: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002

Line 1189: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

1185: CURSOR get_header_info_cur IS
1186: SELECT A.organization_id,
1187: A.location_id,
1188: A.order_type_id
1189: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
1190: WHERE A.delivery_id = B.DELIVERY_ID AND
1191: B.NAME = v_interface_line_attribute3
1192: AND A.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002
1193:

Line 1359: v_ex_inv_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;

1355: v_so_line_id Number;
1356: v_item_type oe_order_lines_all.item_type_code%type;
1357: v_ato_line_id Varchar2(30);
1358: v_config_line_id Number;
1359: v_ex_inv_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;
1360: v_pmt_reg JAI_OM_WSH_LINES_ALL.register%type;
1361: v_pre_prnt_ex_no JAI_OM_WSH_LINES_ALL.preprinted_excise_inv_no%type;
1362: v_ato_line_amount Number;
1363: v_ato_tax_amount Number;

Line 1360: v_pmt_reg JAI_OM_WSH_LINES_ALL.register%type;

1356: v_item_type oe_order_lines_all.item_type_code%type;
1357: v_ato_line_id Varchar2(30);
1358: v_config_line_id Number;
1359: v_ex_inv_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;
1360: v_pmt_reg JAI_OM_WSH_LINES_ALL.register%type;
1361: v_pre_prnt_ex_no JAI_OM_WSH_LINES_ALL.preprinted_excise_inv_no%type;
1362: v_ato_line_amount Number;
1363: v_ato_tax_amount Number;
1364: v_ato_total_amount Number;

Line 1361: v_pre_prnt_ex_no JAI_OM_WSH_LINES_ALL.preprinted_excise_inv_no%type;

1357: v_ato_line_id Varchar2(30);
1358: v_config_line_id Number;
1359: v_ex_inv_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;
1360: v_pmt_reg JAI_OM_WSH_LINES_ALL.register%type;
1361: v_pre_prnt_ex_no JAI_OM_WSH_LINES_ALL.preprinted_excise_inv_no%type;
1362: v_ato_line_amount Number;
1363: v_ato_tax_amount Number;
1364: v_ato_total_amount Number;
1365: -- v_ar3_form_no Number;

Line 1462: FROM JAI_OM_WSH_LINES_ALL

1458: WHERE line_id = v_ato_line_id;
1459:
1460: cursor c_so_picking_data (v_ato_line_id Varchar2) is
1461: SELECT excise_invoice_no , register , preprinted_excise_inv_no , ar3_form_no ,ar3_form_date
1462: FROM JAI_OM_WSH_LINES_ALL
1463: WHERE order_line_id = v_ato_line_id;
1464:
1465: CURSOR so_ato_picking_hdr_info(v_ato_line_id Varchar2) IS
1466: SELECT a.organization_id, a.location_id

Line 1467: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b

1463: WHERE order_line_id = v_ato_line_id;
1464:
1465: CURSOR so_ato_picking_hdr_info(v_ato_line_id Varchar2) IS
1466: SELECT a.organization_id, a.location_id
1467: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b
1468: WHERE a.delivery_id = b.delivery_id and
1469: B.NAME = v_interface_line_attribute3 AND
1470: A.order_line_id = TO_NUMBER(v_ato_line_id);
1471:

Line 2745: from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL table.

2741: 20 2004/02/16 RBASKER - Bug 3357587, Version 618.2
2742: When SO UOM is different from that of the primary UOM,
2743: JAI_AR_TRX_LINES is updated with wrong assessable value
2744: Added a cursor C_JA_SO_LINES_ASSESSABLE_VAL to fetch the correct assessable_value
2745: from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL table.
2746:
2747: 21. 2004/05/05 ssumaith - bug# 3607101 - Version 619.1
2748: When autoinvoice import program imports an invoice from customer software and if interface_line_attribute11
2749: field in the ra_customer_trx_lines_all table is not null then , localization taxes are not retreived

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

2781: bug# 4146708 creates the objects
2782:
2783: 26. 17-Mar-2005 hjujjuru - bug #4245062 File version 115.6
2784: The columns vat_exemption_flag, vat_exemption_type, vat_exemption_date, vat_exemption_refno,
2785: and vat_assessable_value have been added in JAI_OM_OE_SO_LINES, JAI_OM_WSH_LINES_ALL
2786: and JAI_AR_TRX_LINES.
2787: Additional fields vat_invoice_no and vat_invoice_date have been added into JAI_OM_WSH_LINES_ALL
2788: and JAI_AR_TRXS.
2789: The trigger has been updated to ensure that any data flowing into JAI_AR_TRX_LINES and

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

2783: 26. 17-Mar-2005 hjujjuru - bug #4245062 File version 115.6
2784: The columns vat_exemption_flag, vat_exemption_type, vat_exemption_date, vat_exemption_refno,
2785: and vat_assessable_value have been added in JAI_OM_OE_SO_LINES, JAI_OM_WSH_LINES_ALL
2786: and JAI_AR_TRX_LINES.
2787: Additional fields vat_invoice_no and vat_invoice_date have been added into JAI_OM_WSH_LINES_ALL
2788: and JAI_AR_TRXS.
2789: The trigger has been updated to ensure that any data flowing into JAI_AR_TRX_LINES and
2790: JAI_AR_TRXS also includes the Vat information that comes down from either JAI_OM_OE_SO_LINES
2791: or JAI_OM_WSH_LINES_ALL .

Line 2791: or JAI_OM_WSH_LINES_ALL .

2787: Additional fields vat_invoice_no and vat_invoice_date have been added into JAI_OM_WSH_LINES_ALL
2788: and JAI_AR_TRXS.
2789: The trigger has been updated to ensure that any data flowing into JAI_AR_TRX_LINES and
2790: JAI_AR_TRXS also includes the Vat information that comes down from either JAI_OM_OE_SO_LINES
2791: or JAI_OM_WSH_LINES_ALL .
2792:
2793: Base bug - #4245089
2794:
2795: Trigger file name is renamed to JAI_AR_RCTLA_T7.SQL

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

3796: process_bill_only_invoice;
3797: return;
3798: end if;
3799: -- here code returns for an ato imported order because because
3800: -- records do not exist in JAI_OM_WSH_LINES_ALL table
3801: process_taxes_for_ato_order;
3802:
3803:
3804: END IF;

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

4114: IF v_register_code = 'BOND_REG' THEN
4115: v_tax_amount := v_bond_tax_amt / v_qty;
4116: END IF;
4117: -- Bug 3357587
4118: -- To pick assessable_value from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL
4119: OPEN C_JA_SO_LINES_ASSESSABLE_VAL;
4120: FETCH C_JA_SO_LINES_ASSESSABLE_VAL into v_assessable_value,v_service_type;/*5879769..csahoo*/
4121: CLOSE C_JA_SO_LINES_ASSESSABLE_VAL;
4122:

Line 4568: FROM JAI_OM_WSH_LINES_ALL

4564:
4565: -- following cursor definition modified by sriram - bug # 2755890 - 18/01/2003
4566: CURSOR SO_RMA_HDR_INFO IS
4567: SELECT organization_id, location_id
4568: FROM JAI_OM_WSH_LINES_ALL
4569: WHERE order_line_id IN
4570: (SELECT reference_line_id
4571: FROM oe_order_lines_all
4572: WHERE line_id = v_interface_line_attribute7 -- Removed to_char from to_char(line_id) for bug#5641896 by JMEENA

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

4620: FROM JAI_AR_TRXS
4621: WHERE customer_trx_id = v_header_id;
4622:
4623:
4624: /* Cursor To Check Whether Interfaced Record Exist in JAI_OM_WSH_LINES_ALL */
4625: CURSOR SO_RMA_RECORD_CHECK IS
4626: SELECT 1
4627: FROM JAI_OM_OE_RMA_LINES
4628: WHERE rma_line_id = v_interface_line_attribute7;