APPS.JA_JAINSTPR_XMLP_PKG SQL Statements

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

Line: 13

      SELECT
        SUM(DIFF_AMT) EXCISE
      FROM
        JAI_AR_SUP_TAXES A,
        JAI_AR_SUP_LINES B,
        JAI_AR_SUP_HDRS_ALL C
      WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
        AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE
        AND B.CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
        AND B.SUP_INV_TYPE = A.SUP_INV_TYPE
        AND C.CUSTOMER_TRX_ID = excise_taxformula.CUSTOMER_TRX_ID
        AND C.SUPP_INV_TYPE = excise_taxformula.SUPP_INV_TYPE
        AND EXISTS (
        SELECT
          1
        FROM
          JAI_CMN_TAXES_ALL D
        WHERE TAX_TYPE LIKE CP_TAX_TYPE
          AND D.TAX_ID = A.NEW_TAX_ID )
      GROUP BY
        C.CUSTOMER_TRX_ID,
        C.SUPP_INV_TYPE;

Line: 48

      SELECT
        SUM(DIFF_AMT) SALES
      FROM
        JAI_AR_SUP_TAXES A,
        JAI_AR_SUP_LINES B,
        JAI_AR_SUP_HDRS_ALL C
      WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
        AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE
        AND B.CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
        AND B.SUP_INV_TYPE = A.SUP_INV_TYPE
        AND C.CUSTOMER_TRX_ID = cf_5formula.CUSTOMER_TRX_ID
        AND C.SUPP_INV_TYPE = cf_5formula.SUPP_INV_TYPE
        AND EXISTS (
        SELECT
          1
        FROM
          JAI_CMN_TAXES_ALL D
        WHERE TAX_TYPE LIKE CP_TAX_TYPE
          AND D.TAX_ID = A.NEW_TAX_ID )
      GROUP BY
        C.CUSTOMER_TRX_ID,
        C.SUPP_INV_TYPE;

Line: 83

      SELECT
        SUM(DIFF_AMT) EXCISE
      FROM
        JAI_AR_SUP_TAXES A,
        JAI_AR_SUP_LINES B,
        JAI_AR_SUP_HDRS_ALL C
      WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
        AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE
        AND B.CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
        AND B.SUP_INV_TYPE = A.SUP_INV_TYPE
        AND C.CUSTOMER_TRX_ID = cstformula.CUSTOMER_TRX_ID
        AND C.SUPP_INV_TYPE = cstformula.SUPP_INV_TYPE
        AND EXISTS (
        SELECT
          1
        FROM
          JAI_CMN_TAXES_ALL D
        WHERE TAX_TYPE LIKE CP_TAX_TYPE
          AND D.TAX_ID = A.NEW_TAX_ID )
      GROUP BY
        C.CUSTOMER_TRX_ID,
        C.SUPP_INV_TYPE;

Line: 121

      SELECT
        SUM(DIFF_AMT) OTHER
      FROM
        JAI_AR_SUP_TAXES A,
        JAI_AR_SUP_LINES B,
        JAI_AR_SUP_HDRS_ALL C
      WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
        AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE
        AND B.CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
        AND B.SUP_INV_TYPE = A.SUP_INV_TYPE
        AND C.CUSTOMER_TRX_ID = others_formula.CUSTOMER_TRX_ID
        AND C.SUPP_INV_TYPE = others_formula.SUPP_INV_TYPE
        AND EXISTS (
        SELECT
          1
        FROM
          JAI_CMN_TAXES_ALL D
        WHERE TAX_TYPE not LIKE LV_EXCISE
          AND TAX_TYPE NOT LIKE LV_CST
          AND TAX_TYPE not like LV_SALES_TAX
          AND D.TAX_ID = A.NEW_TAX_ID )
      GROUP BY
        C.CUSTOMER_TRX_ID,
        C.SUPP_INV_TYPE;

Line: 160

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

Line: 170

      SELECT
        NAME
      FROM
        V$DATABASE;

Line: 180

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

Line: 229

    UPDATE
      JAI_AR_SUP_HDRS_ALL
    SET
      PROCESS_DATE = SYSDATE
    WHERE PROCESS_DATE is null;