APPS.JA_JAINVATR_XMLP_PKG SQL Statements

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

Line: 5

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

Line: 13

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

Line: 24

      SELECT
        NVL(NAME
           ,'')
      FROM
        V$DATABASE;

Line: 30

      SELECT
        DISTINCT
        JORRV.ATTRIBUTE_CODE
      FROM
        JAI_RGM_ORG_REGNS_V JORRV
      WHERE JORRV.REGIME_CODE = 'VAT'
        AND JORRV.REGISTRATION_TYPE = 'TAX_TYPES';

Line: 97

      SELECT
        ROUND(SUM(JISPL.SELLING_PRICE * JISPL.QUANTITY)
             ,2)
      FROM
        JAI_OM_WSH_LINES_ALL JISPL,
        OE_ORDER_HEADERS_ALL OOHA
      WHERE OOHA.ORDER_SOURCE_ID = 10
        AND JISPL.ORDER_HEADER_ID = OOHA.HEADER_ID
        AND JISPL.ORDER_TYPE_ID = OOHA.ORDER_TYPE_ID
        AND JISPL.ORGANIZATION_ID = A_ORGANIZATION_ID
        AND JISPL.LOCATION_ID = A_LOCATION_ID
        AND TRUNC(JISPL.CREATION_DATE) BETWEEN P_FROM_DATE
        AND P_TO_DATE;

Line: 123

      SELECT
        SUM(PRLA.UNIT_PRICE * RT.PRIMARY_QUANTITY)
      FROM
        PO_REQUISITION_LINES_ALL PRLA,
        RCV_TRANSACTIONS RT
      WHERE PRLA.REQUISITION_LINE_ID = RT.REQUISITION_LINE_ID
        AND PRLA.DESTINATION_ORGANIZATION_ID = A_ORGANIZATION_ID
        AND PRLA.DELIVER_TO_LOCATION_ID = A_LOCATION_ID
        AND RT.SOURCE_DOCUMENT_CODE = 'REQ'
        AND RT.TRANSACTION_DATE BETWEEN P_FROM_DATE
        AND P_TO_DATE;

Line: 179

      SELECT
        SUM(JRRL.RECOVERED_AMOUNT)
      FROM
        JAI_RCV_RGM_LINES JRRL
      WHERE JRRL.REGIME_ITEM_CLASS = 'CG'
        AND JRRL.ORGANIZATION_ID = A_ORGANIZATION_ID
        AND JRRL.LOCATION_ID = A_LOCATION_ID
        AND TRUNC(JRRL.RECEIPT_DATE) BETWEEN P_FROM_DATE
        AND P_TO_DATE;