APPS.JA_JAINSITR_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 = L_CUSTOMER_TRX_ID
        AND C.SUPP_INV_TYPE = L_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 = L_CUSTOMER_TRX_ID
        AND C.SUPP_INV_TYPE = L_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 = L_CUSTOMER_TRX_ID
        AND C.SUPP_INV_TYPE = L_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 = L_CUSTOMER_TRX_ID
        AND C.SUPP_INV_TYPE = L_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
        CONCURRENT_PROGRAM_ID,
        NVL(ENABLE_TRACE
           ,'N')
      FROM
        FND_CONCURRENT_REQUESTS
      WHERE REQUEST_ID = P_REQUEST_ID;