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.JA_JAIN23P2_XMLP_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 87: JAI_CMN_RG_23AC_II_TRXS A,

83: SUM(NVL(CREDIT
84: ,0) - NVL(DEBIT
85: ,0))
86: FROM
87: JAI_CMN_RG_23AC_II_TRXS A,
88: JAI_CMN_RG_OTHERS B
89: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
90: AND LOCATION_ID = P_LOCATION_ID
91: AND REGISTER_TYPE = P_REGISTER_TYPE

Line 225: JAI_CMN_RG_23AC_II_TRXS

221: ,0) - NVL(DR_OTHER_ED
222: ,0))
223: INTO LN_DELTA_AMOUNT
224: FROM
225: JAI_CMN_RG_23AC_II_TRXS
226: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
227: AND LOCATION_ID = P_LOCATION_ID
228: AND REGISTER_TYPE = P_REGISTER_TYPE
229: AND TRUNC(CREATION_DATE) > LD_DELTA_START_DATE

Line 511: JAI_CMN_RG_23AC_II_TRXS A

507: CURSOR C_CHK_PARENT_INCLUDED(P_REGISTER_ID IN NUMBER) IS
508: SELECT
509: COUNT(1)
510: FROM
511: JAI_CMN_RG_23AC_II_TRXS A
512: WHERE A.ORGANIZATION_ID = P_ORGANIZATION_ID
513: AND A.LOCATION_ID = P_LOCATION_ID
514: AND REGISTER_TYPE = P_REGISTER_TYPE
515: AND A.INVENTORY_ITEM_ID <> 0

Line 519: V_ROUND_AMOUNT JAI_CMN_RG_23AC_II_TRXS.CR_BASIC_ED%TYPE := 0;

515: AND A.INVENTORY_ITEM_ID <> 0
516: AND REGISTER_ID = P_REGISTER_ID
517: AND TRUNC(CREATION_DATE) BETWEEN P_TRN_FROM_DATE
518: AND P_TRN_TO_DATE;
519: V_ROUND_AMOUNT JAI_CMN_RG_23AC_II_TRXS.CR_BASIC_ED%TYPE := 0;
520: V_RND_ENTRY_CNT NUMBER;
521: V_PARENT_REGISTER_ID NUMBER;
522: V_PARENT_INCLUDED_CNT NUMBER;
523: V_TOTAL_ROUND_AMOUNT NUMBER := 0;

Line 576: JAI_CMN_RG_23AC_II_TRXS

572: NVL(CR_OTHER_ED
573: ,0) - NVL(DR_OTHER_ED
574: ,0) OTHER_AMOUNT
575: FROM
576: JAI_CMN_RG_23AC_II_TRXS
577: WHERE EXCISE_INVOICE_NO = CF_ROUNDING_AMOUNTFORMULA.EXCISE_INVOICE_NO
578: AND EXCISE_INVOICE_DATE = CF_ROUNDING_AMOUNTFORMULA.EXCISE_INVOICE_DATE
579: AND INVENTORY_ITEM_ID = 0
580: AND TRANSACTION_SOURCE_NUM = 18

Line 682: JAI_CMN_RG_23AC_II_TRXS

678: CURSOR C_GET_REMARKS IS
679: SELECT
680: REMARKS
681: FROM
682: JAI_CMN_RG_23AC_II_TRXS
683: WHERE ( EXCISE_INVOICE_NO IS NULL
684: OR EXCISE_INVOICE_NO = EXCISE_INVOICE_NO_1 )
685: AND ( EXCISE_INVOICE_DATE IS NULL
686: OR EXCISE_INVOICE_DATE = EXCISE_INVOICE_DATE_1 )

Line 706: LV_REMARKS JAI_CMN_RG_23AC_II_TRXS.REMARKS%TYPE;

702: RCV_TRANSACTIONS RTRAN
703: WHERE rtran.transaction_id (+) = RECEIPT_ID
704: AND rcv.shipment_header_id (+) = RTRAN.SHIPMENT_HEADER_ID;
705: V_RECEIPT_NUM RCV_SHIPMENT_HEADERS.RECEIPT_NUM%TYPE;
706: LV_REMARKS JAI_CMN_RG_23AC_II_TRXS.REMARKS%TYPE;
707: BEGIN
708: V_RECEIPT_NUM := ' ';
709: LV_REMARKS := '';
710: BEGIN

Line 736: JAI_CMN_RG_23AC_II_TRXS RG23_2,

732: CURSOR C_GET_FOLIO_PART_I IS
733: SELECT
734: RG23_1.INVENTORY_ITEM_ID || '-' || RG23_1.SLNO FOLIO
735: FROM
736: JAI_CMN_RG_23AC_II_TRXS RG23_2,
737: JAI_CMN_RG_23AC_I_TRXS RG23_1
738: WHERE RG23_2.ORGANIZATION_ID = P_ORGANIZATION_ID
739: AND RG23_2.LOCATION_ID = P_LOCATION_ID
740: AND RG23_2.EXCISE_INVOICE_NO = P_EXCISE_INVOICE_NO

Line 749: JAI_CMN_RG_23AC_II_TRXS RG23_2,

745: UNION
746: SELECT
747: (RG_1.INVENTORY_ITEM_ID || '-' || RG_1.SLNO) FOLIO
748: FROM
749: JAI_CMN_RG_23AC_II_TRXS RG23_2,
750: JAI_CMN_RG_I_TRXS RG_1
751: WHERE RG23_2.ORGANIZATION_ID = P_ORGANIZATION_ID
752: AND RG23_2.LOCATION_ID = P_LOCATION_ID
753: AND RG23_2.EXCISE_INVOICE_NO = P_EXCISE_INVOICE_NO

Line 814: JAI_CMN_RG_23AC_II_TRXS

810: AND SOURCE_REGISTER_ID IN (
811: SELECT
812: REGISTER_ID
813: FROM
814: JAI_CMN_RG_23AC_II_TRXS
815: WHERE ( ( EXCISE_INVOICE_NO IS NULL
816: AND EXCISE_INVOICE_NO IS NULL )
817: OR ( EXCISE_INVOICE_NO = EXCISE_INVOICE_NO_1 ) )
818: AND ( ( EXCISE_INVOICE_DATE IS NULL

Line 870: JAI_CMN_RG_23AC_II_TRXS

866: AND SOURCE_REGISTER_ID IN (
867: SELECT
868: REGISTER_ID
869: FROM
870: JAI_CMN_RG_23AC_II_TRXS
871: WHERE ( ( EXCISE_INVOICE_NO IS NULL
872: AND EXCISE_INVOICE_NO IS NULL )
873: OR ( EXCISE_INVOICE_NO = EXCISE_INVOICE_NO_1 ) )
874: AND ( ( EXCISE_INVOICE_DATE IS NULL

Line 923: JAI_CMN_RG_23AC_II_TRXS

919: CURSOR CUR_REG_ID IS
920: SELECT
921: REGISTER_ID
922: FROM
923: JAI_CMN_RG_23AC_II_TRXS
924: WHERE RECEIPT_REF = RECEIPT_ID;
925: LV_REG_ID JAI_CMN_RG_23AC_II_TRXS.REGISTER_ID%TYPE;
926: BEGIN
927: OPEN CUR_REG_ID;

Line 925: LV_REG_ID JAI_CMN_RG_23AC_II_TRXS.REGISTER_ID%TYPE;

921: REGISTER_ID
922: FROM
923: JAI_CMN_RG_23AC_II_TRXS
924: WHERE RECEIPT_REF = RECEIPT_ID;
925: LV_REG_ID JAI_CMN_RG_23AC_II_TRXS.REGISTER_ID%TYPE;
926: BEGIN
927: OPEN CUR_REG_ID;
928: FETCH CUR_REG_ID
929: INTO LV_REG_ID;

Line 1019: JAI_CMN_RG_23AC_II_TRXS

1015: AND SOURCE_REGISTER_ID IN (
1016: SELECT
1017: REGISTER_ID
1018: FROM
1019: JAI_CMN_RG_23AC_II_TRXS
1020: WHERE ( ( EXCISE_INVOICE_NO IS NULL
1021: AND EXCISE_INVOICE_NO IS NULL )
1022: OR ( EXCISE_INVOICE_NO = EXCISE_INVOICE_NO_1 ) )
1023: AND ( ( EXCISE_INVOICE_DATE IS NULL

Line 1083: JAI_CMN_RG_23AC_II_TRXS

1079: AND SOURCE_REGISTER_ID IN (
1080: SELECT
1081: REGISTER_ID
1082: FROM
1083: JAI_CMN_RG_23AC_II_TRXS
1084: WHERE ( ( EXCISE_INVOICE_NO IS NULL
1085: AND EXCISE_INVOICE_NO IS NULL )
1086: OR ( EXCISE_INVOICE_NO = EXCISE_INVOICE_NO_1 ) )
1087: AND ( ( EXCISE_INVOICE_DATE IS NULL

Line 1147: JAI_CMN_RG_23AC_II_TRXS

1143: AND SOURCE_REGISTER_ID IN (
1144: SELECT
1145: REGISTER_ID
1146: FROM
1147: JAI_CMN_RG_23AC_II_TRXS
1148: WHERE ( ( EXCISE_INVOICE_NO IS NULL
1149: AND EXCISE_INVOICE_NO IS NULL )
1150: OR ( EXCISE_INVOICE_NO = EXCISE_INVOICE_NO_1 ) )
1151: AND ( ( EXCISE_INVOICE_DATE IS NULL

Line 1211: JAI_CMN_RG_23AC_II_TRXS

1207: AND SOURCE_REGISTER_ID IN (
1208: SELECT
1209: REGISTER_ID
1210: FROM
1211: JAI_CMN_RG_23AC_II_TRXS
1212: WHERE ( ( EXCISE_INVOICE_NO IS NULL
1213: AND EXCISE_INVOICE_NO IS NULL )
1214: OR ( EXCISE_INVOICE_NO = EXCISE_INVOICE_NO_1 ) )
1215: AND ( ( EXCISE_INVOICE_DATE IS NULL