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_TRXS_PKG dependencies on DUAL

Line 514: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;

510: );
511:
512:
513: vsqlstmt := '20';
514: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;
515: ELSIF v_item_class IN ('CGEX','CGIN') THEN
516: v_reg_type := 'C';
517: ELSIF v_item_class IN ('RMIN','RMEX') THEN
518: v_reg_type := 'A';

Line 533: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;

529: v_customer_trx_id, SYSDATE, v_reg_code,
530: v_creation_date, v_created_by,v_last_update_date,
531: v_last_updated_by, v_last_update_login );
532: vsqlstmt := '22';
533: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;
534: END IF;
535: END IF;
536: IF v_reg_code in ('DOMESTIC_EXCISE','EXPORT_EXCISE') THEN
537:

Line 633: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;

629: );
630: vsqlstmt := '26';
631: END IF;
632: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') THEN
633: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
634: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
635: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
636: UPDATE JAI_CMN_RG_I_TRXS
637: SET register_id_part_ii = v_rg23_part_ii_no,

Line 635: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;

631: END IF;
632: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') THEN
633: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
634: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
635: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
636: UPDATE JAI_CMN_RG_I_TRXS
637: SET register_id_part_ii = v_rg23_part_ii_no,
638: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
639: WHERE register_id = v_rg23_part_ii_no)

Line 642: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;

638: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
639: WHERE register_id = v_rg23_part_ii_no)
640: WHERE register_id = v_rg23_part_i_no;
641: ELSIF l_rec.payment_register IN( 'PLA') THEN
642: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;
643: UPDATE JAI_CMN_RG_I_TRXS
644: SET register_id_part_ii = v_pla_register_no,
645: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS
646: WHERE register_id = v_pla_register_no)

Line 650: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;

646: WHERE register_id = v_pla_register_no)
647: WHERE register_id = v_rg23_part_i_no;
648: END IF;
649: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') THEN
650: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
651: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
652: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
653: UPDATE JAI_CMN_RG_23AC_I_TRXS
654: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,

Line 652: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;

648: END IF;
649: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') THEN
650: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
651: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
652: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
653: UPDATE JAI_CMN_RG_23AC_I_TRXS
654: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
655: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
656: WHERE register_id = v_rg23_part_ii_no)

Line 659: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;

655: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
656: WHERE register_id = v_rg23_part_ii_no)
657: WHERE register_id = v_rg23_part_i_no;
658: ELSIF l_rec.payment_register IN( 'PLA') THEN
659: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;
660: UPDATE JAI_CMN_RG_23AC_I_TRXS
661: SET REGISTER_ID_PART_II = v_pla_register_no,
662: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS
663: WHERE register_id = v_pla_register_no)

Line 716: Select JAI_CMN_RG_23D_TRXS_S.NEXTVAL into v_register_id From Dual;

712: v_match_tax_rate := v_match_tax_rate/v_tax_rate_counter;
713: END IF;
714: END LOOP;
715:
716: Select JAI_CMN_RG_23D_TRXS_S.NEXTVAL into v_register_id From Dual;
717: IF match_rec.transaction_type = 'R'
718: THEN
719: v_rg23d_receipt_id := match_rec.receipt_id;
720: ELSIF match_rec.transaction_type = 'CR'