APPS.JA_JAINRG1_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 108

      SELECT
        BALANCE_PACKED
      FROM
        JAI_CMN_RG_I_TRXS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND LOCATION_ID = P_LOCATION_ID
        AND FIN_YEAR = FIN_YEAR_1
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
        AND SLNO = SLNO_1 - 1;

Line: 118

      SELECT
        BALANCE_PACKED
      FROM
        JAI_CMN_RG_I_TRXS
      WHERE ORGANIZATION_ID = P_ORGN_ID
        AND LOCATION_ID = P_LOC_ID
        AND FIN_YEAR = P_FIN_YEAR
        AND INVENTORY_ITEM_ID = P_ITEM_ID
        AND SLNO = (
        SELECT
          MAX(SLNO)
        FROM
          JAI_CMN_RG_I_TRXS
        WHERE ORGANIZATION_ID = P_ORGN_ID
          AND LOCATION_ID = P_LOC_ID
          AND FIN_YEAR = P_FIN_YEAR
          AND INVENTORY_ITEM_ID = P_ITEM_ID );

Line: 212

      SELECT
        BALANCE_LOOSE
      FROM
        JAI_CMN_RG_I_TRXS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND LOCATION_ID = P_LOCATION_ID
        AND FIN_YEAR = FIN_YEAR_1
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
        AND SLNO = SLNO_1 - 1;

Line: 222

      SELECT
        BALANCE_LOOSE
      FROM
        JAI_CMN_RG_I_TRXS
      WHERE ORGANIZATION_ID = P_ORGN_ID
        AND LOCATION_ID = P_LOC_ID
        AND FIN_YEAR = P_FIN_YEAR
        AND INVENTORY_ITEM_ID = P_ITEM_ID
        AND SLNO = (
        SELECT
          MAX(SLNO)
        FROM
          JAI_CMN_RG_I_TRXS
        WHERE ORGANIZATION_ID = P_ORGN_ID
          AND LOCATION_ID = P_LOC_ID
          AND FIN_YEAR = P_FIN_YEAR
          AND INVENTORY_ITEM_ID = P_ITEM_ID );

Line: 280

      SELECT
        CONCURRENT_PROGRAM_ID,
        NVL(ENABLE_TRACE
           ,'N')
      FROM
        FND_CONCURRENT_REQUESTS
      WHERE REQUEST_ID = P_REQUEST_ID;

Line: 288

      SELECT
        A.SID,
        A.SERIAL#,
        B.SPID
      FROM
        V$SESSION A,
        V$PROCESS B
      WHERE AUDSID = USERENV('SESSIONID')
        AND A.PADDR = B.ADDR;

Line: 298

      SELECT
        NAME
      FROM
        V$DATABASE;

Line: 354

      SELECT
        SLNO
      FROM
        JAI_CMN_RG_23AC_II_TRXS
      WHERE REGISTER_ID = P_REGISTER_ID;

Line: 360

      SELECT
        SLNO
      FROM
        JAI_CMN_RG_PLA_TRXS
      WHERE REGISTER_ID = P_REGISTER_ID;

Line: 398

      SELECT
        DECODE(SUM(CREDIT)
              ,NULL
              ,SUM(DEBIT)
              ,SUM(CREDIT)) CESS_AMT
      FROM
        JAI_CMN_RG_OTHERS RGOTH
      WHERE RGOTH.SOURCE_TYPE = DECODE(PAYMENT_REGISTER
            ,LV_RG23A
            ,1
            ,LV_RG23C
            ,1
            ,LV_PLA
            ,2)
        AND RGOTH.SOURCE_REGISTER_ID = REGISTER_ID_PART_II
        AND RGOTH.TAX_TYPE IN ( 'EXCISE_EDUCATION_CESS' , 'CVD_EDUCATION_CESS' );

Line: 415

      SELECT
        JSPTL.TAX_RATE CESS_RATE
      FROM
        JAI_OM_WSH_LINES_ALL JSPL,
        JAI_OM_WSH_LINE_TAXES JSPTL,
        JAI_CMN_TAXES_ALL JTC
      WHERE JSPL.DELIVERY_DETAIL_ID = JSPTL.DELIVERY_DETAIL_ID
        AND JSPTL.TAX_ID = JTC.TAX_ID
        AND UPPER(JTC.TAX_TYPE) IN ( 'EXCISE_EDUCATION_CESS' , 'CVD_EDUCATION_CESS' )
        AND JSPL.DELIVERY_DETAIL_ID = REF_DOC_NO;

Line: 426

      SELECT
        JRCTTL.TAX_RATE CESS_RATE
      FROM
        JAI_AR_TRX_LINES JRCTL,
        JAI_AR_TRX_TAX_LINES JRCTTL,
        JAI_CMN_TAXES_ALL JTC
      WHERE JRCTL.CUSTOMER_TRX_LINE_ID = JRCTTL.LINK_TO_CUST_TRX_LINE_ID
        AND JRCTTL.TAX_ID = JTC.TAX_ID
        AND UPPER(JTC.TAX_TYPE) IN ( 'EXCISE_EDUCATION_CESS' , 'CVD_EDUCATION_CESS' )
        AND JRCTL.CUSTOMER_TRX_ID = REF_DOC_NO;

Line: 481

      SELECT
        DECODE(SUM(CREDIT)
              ,NULL
              ,SUM(DEBIT)
              ,SUM(CREDIT)) CESS_AMT
      FROM
        JAI_CMN_RG_OTHERS RGOTH
      WHERE RGOTH.SOURCE_TYPE = DECODE(PAYMENT_REGISTER
            ,'RG23A'
            ,1
            ,'RG23C'
            ,1
            ,'PLA'
            ,2)
        AND RGOTH.SOURCE_REGISTER_ID = REGISTER_ID_PART_II
        AND RGOTH.TAX_TYPE IN ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' );

Line: 498

      SELECT
        ISSUE_TYPE
      FROM
        JAI_CMN_RG_I_TRXS
      WHERE REGISTER_ID = REGISTER_ID_1;

Line: 505

      SELECT
        JSPTL.TAX_RATE CESS_RATE
      FROM
        JAI_OM_WSH_LINES_ALL JSPL,
        JAI_OM_WSH_LINE_TAXES JSPTL,
        JAI_CMN_TAXES_ALL JTC
      WHERE JSPL.DELIVERY_DETAIL_ID = JSPTL.DELIVERY_DETAIL_ID
        AND JSPTL.TAX_ID = JTC.TAX_ID
        AND UPPER(JTC.TAX_TYPE) IN ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' )
        AND JSPL.DELIVERY_DETAIL_ID = REF_DOC_NO;

Line: 516

      SELECT
        JRCTTL.TAX_RATE CESS_RATE
      FROM
        JAI_AR_TRX_LINES JRCTL,
        JAI_AR_TRX_TAX_LINES JRCTTL,
        JAI_CMN_TAXES_ALL JTC
      WHERE JRCTL.CUSTOMER_TRX_LINE_ID = JRCTTL.LINK_TO_CUST_TRX_LINE_ID
        AND JRCTTL.TAX_ID = JTC.TAX_ID
        AND UPPER(JTC.TAX_TYPE) IN ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' )
        AND JRCTL.CUSTOMER_TRX_ID = REF_DOC_NO;