APPS.JA_JAINTSLS_XMLP_PKG SQL Statements

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

Line: 28

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

Line: 63

      SELECT
        MIN(CUTX.TRX_DATE)
      INTO P_START_DATE
      FROM
        RA_CUSTOMER_TRX_ALL CUTX,
        JAI_AR_TRXS JCUTX,
        RA_CUSTOMER_TRX_LINES_ALL CUTXL,
        JAI_CMN_CUS_ADDRESSES JCUAD,
        JAI_AR_TRX_TAX_LINES JRCTAXL,
        JAI_CMN_TAXES_ALL JITC,
        AR_PAYMENT_SCHEDULES_ALL ARPS
      WHERE JCUTX.ORGANIZATION_ID = P_ORGANIZATION_ID
        AND CUTX.CUSTOMER_TRX_ID = JCUTX.CUSTOMER_TRX_ID
        AND CUTXL.CUSTOMER_TRX_ID = CUTX.CUSTOMER_TRX_ID
        AND JRCTAXL.LINK_TO_CUST_TRX_LINE_ID = CUTXL.CUSTOMER_TRX_LINE_ID
        AND JITC.TAX_ID = JRCTAXL.TAX_ID
        AND ( UPPER(JITC.TAX_TYPE) like LV_SALES
      OR UPPER(JITC.TAX_TYPE) like LV_CST )
        AND UPPER(CUTX.COMPLETE_FLAG) = 'Y'
        AND ARPS.CUSTOMER_TRX_ID = CUTX.CUSTOMER_TRX_ID
        AND jcuad.customer_id (+) = CUTX.SOLD_TO_CUSTOMER_ID;

Line: 103

      SELECT
        SUM(A.TAX_AMOUNT)
      INTO EXCISE_TAX
      FROM
        JAI_AR_TRX_TAX_LINES A,
        JAI_CMN_TAXES_ALL B
      WHERE A.LINK_TO_CUST_TRX_LINE_ID = CF_1FORMULA0004.CUSTOMER_TRX_LINE_ID
        AND A.TAX_ID = B.TAX_ID
        AND UPPER(B.TAX_TYPE) IN ( LV_EXCISE , LV_ADDL_EXCISE , LV_OTHER_EXCISE , LV_EXC_EDU_CESS , LV_SH_EXC_EDU_CESS );

Line: 137

      SELECT
        SUM(A.TAX_AMOUNT)
      INTO OTHER_TAX
      FROM
        JAI_AR_TRX_TAX_LINES A,
        JAI_CMN_TAXES_ALL B
      WHERE A.LINK_TO_CUST_TRX_LINE_ID = CF_2FORMULA.CUSTOMER_TRX_LINE_ID
        AND A.TAX_ID = B.TAX_ID
        AND UPPER(B.TAX_TYPE) NOT IN ( LV_EXCISE , LV_ADDL_EXCISE , LV_OTHER_EXCISE , LV_EXC_EDU_CESS , LV_SALES_TAX , LV_CST , LV_SH_EXC_EDU_CESS );

Line: 156

    SELECT
      SUM(NVL(LINE_AMOUNT
             ,0)) + SUM(NVL(TAX_AMOUNT
             ,0))
    INTO V_TOTAL_AMOUNT
    FROM
      JAI_AR_TRX_LINES
    WHERE CUSTOMER_TRX_ID = CF_1FORMULA0013.CUSTOMER_TRX_ID;

Line: 172

      SELECT
        CONCATENATED_SEGMENTS
      FROM
        GL_CODE_COMBINATIONS_KFV
      WHERE CODE_COMBINATION_ID = P_CODE_COMBINATION_ID;

Line: 210

      SELECT
        SUM(NVL(EXTENDED_AMOUNT
               ,0))
      FROM
        RA_CUSTOMER_TRX_LINES_ALL
      WHERE CUSTOMER_TRX_ID = CF_1FORMULA0005.CUSTOMER_TRX_ID
        AND LINE_TYPE = CP_LINE_TYPE
        AND SALES_ORDER_LINE = ORDER_LINE_ID
      GROUP BY
        SALES_ORDER_LINE;

Line: 221

      SELECT
        CREATED_FROM
      FROM
        RA_CUSTOMER_TRX_ALL
      WHERE CUSTOMER_TRX_ID = CF_1FORMULA0005.CUSTOMER_TRX_ID;

Line: 281

    SELECT
      SUM(A.FUNC_TAX_AMOUNT)
    INTO VAT_TAX
    FROM
      JAI_AR_TRX_TAX_LINES A,
      JAI_CMN_TAXES_ALL B
    WHERE A.LINK_TO_CUST_TRX_LINE_ID = CF_VAT_TAXES_1.CUSTOMER_TRX_LINE_ID
      AND A.TAX_ID = B.TAX_ID
      AND UPPER(B.TAX_TYPE) IN (
      SELECT
        TAX_TYPE
      FROM
        JAI_REGIME_TAX_TYPES_V
      WHERE REGIME_CODE = 'VAT' );