APPS.JA_JAINARE1_XMLP_PKG SQL Statements

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

Line: 5

      SELECT
        TOWN_OR_CITY
      FROM
        HR_LOCATIONS
      WHERE LOCATION_ID = P_LOCATION_ID;

Line: 11

      SELECT
        LOCATION_ID
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 17

      SELECT
        LEGAL_ENTITY
      FROM
        ORG_ORGANIZATION_DEFINITIONS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 43

      SELECT
        NAME
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = P_LEGAL_ENTITY_ID;

Line: 49

      SELECT
        LEGAL_ENTITY
      FROM
        ORG_ORGANIZATION_DEFINITIONS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 70

      SELECT
        CUST_ACCT_SITE_ID ADDRESS_ID
      FROM
        HZ_CUST_SITE_USES_ALL
      WHERE SITE_USE_ID = P_SITE_USE_ID;

Line: 76

      SELECT
        HZL.COUNTRY COUNTRY
      FROM
        HZ_LOCATIONS HZL,
        HZ_PARTY_SITES HZPS,
        HZ_CUST_ACCT_SITES_ALL HZCAS
      WHERE HZL.LOCATION_ID = HZPS.LOCATION_ID
        AND HZPS.PARTY_SITE_ID = HZCAS.PARTY_SITE_ID
        AND HZCAS.CUST_ACCT_SITE_ID = P_ADDRESS_ID;

Line: 115

      SELECT
        JISPTL.TAX_RATE
      FROM
        JAI_CMN_TAXES_ALL JTC,
        JAI_OM_WSH_LINE_TAXES JISPTL
      WHERE JISPTL.DELIVERY_DETAIL_ID in (
        SELECT
          DELIVERY_DETAIL_ID
        FROM
          JAI_OM_WSH_LINES_ALL
        WHERE DELIVERY_ID = P_DELIVERY_ID
          AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID )
        AND JTC.TAX_ID = JISPTL.TAX_ID
        AND JTC.TAX_TYPE like '%Excise%';

Line: 145

      SELECT
        CONFIRM_DATE
      FROM
        WSH_NEW_DELIVERIES
      WHERE DELIVERY_ID = P_DELIVERY_ID;

Line: 151

      SELECT
        CONVERSION_TYPE_CODE,
        CONVERSION_RATE,
        TRANSACTIONAL_CURR_CODE
      FROM
        OE_ORDER_HEADERS_ALL
      WHERE HEADER_ID = P_HEADER_ID;

Line: 159

      SELECT
        UNIT_SELLING_PRICE
      FROM
        OE_ORDER_LINES_ALL
      WHERE LINE_ID = P_LINE_ID
        AND HEADER_ID = P_HEADER_ID;

Line: 219

      SELECT
        SET_OF_BOOKS_ID
      FROM
        ORG_ORGANIZATION_DEFINITIONS
      WHERE ORGANIZATION_ID = P_OPERATING_UNIT_ID;

Line: 235

      SELECT
        CURRENCY_CODE
      FROM
        GL_SETS_OF_BOOKS
      WHERE SET_OF_BOOKS_ID = P_SOB;

Line: 257

      SELECT
        SUM(DECODE(UPPER(TAX_TYPE)
                  ,'EXCISE'
                  ,JISPTL.FUNC_TAX_AMOUNT
                  ,'OTHER EXCISE'
                  ,JISPTL.FUNC_TAX_AMOUNT
                  ,'ADDL. EXCISE'
                  ,JISPTL.FUNC_TAX_AMOUNT
                  ,0)) EXCISE,
        SUM(DECODE(UPPER(TAX_TYPE)
                  ,'EXCISE_EDUCATION_CESS'
                  ,JISPTL.FUNC_TAX_AMOUNT
                  ,0)) EXCISE_CESS,
        SUM(DECODE(UPPER(TAX_TYPE)
                  ,'EXCISE_SH_EDU_CESS'
                  ,JISPTL.FUNC_TAX_AMOUNT
                  ,0)) EXCISE_SH_CESS
      FROM
        JAI_CMN_TAXES_ALL JTC,
        JAI_OM_WSH_LINE_TAXES JISPTL
      WHERE JISPTL.DELIVERY_DETAIL_ID in (
        SELECT
          DELIVERY_DETAIL_ID
        FROM
          JAI_OM_WSH_LINES_ALL
        WHERE DELIVERY_ID = P_DELIVERY_ID
          AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID )
        AND JTC.TAX_ID = JISPTL.TAX_ID
        AND JTC.TAX_TYPE like '%Excise%';

Line: 305

      SELECT
        NVL(ENABLE_TRACE
           ,'N'),
        A.CONCURRENT_PROGRAM_ID
      FROM
        FND_CONCURRENT_PROGRAMS A,
        FND_APPLICATION B
      WHERE B.APPLICATION_SHORT_NAME = CP_APP_SHORT_NAME
        AND B.APPLICATION_ID = A.APPLICATION_ID
        AND A.CONCURRENT_PROGRAM_NAME = CP_CON_PROGRAM_NAME;

Line: 316

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

Line: 326

      SELECT
        NAME
      FROM
        V$DATABASE;

Line: 376

      SELECT
        ( NVL(TRANSACTION_AMOUNT
           ,0) + NVL(EDU_CESS_AMOUNT
           ,0) + NVL(RG23D_REGISTER_BALANCE
           ,0) + NVL(SH_CESS_AMOUNT
           ,0) ) DEBIT,
        REGISTER_BALANCE CLOSING_BAL,
        ( NVL(TRANSACTION_AMOUNT
           ,0) + NVL(EDU_CESS_AMOUNT
           ,0) + NVL(RG23D_REGISTER_BALANCE
           ,0) + NVL(REGISTER_BALANCE
           ,0) + NVL(SH_CESS_AMOUNT
           ,0) ) OPENING_BAL
      FROM
        JAI_OM_OE_BOND_TRXS
      WHERE TRANSACTION_NAME = CP_TRANSACTION_NAME
        AND ORDER_HEADER_ID = CF_BALANCESFORMULA.ORDER_HEADER_ID
        AND ORDER_FLAG = 'Y'
        AND TRANSACTION_ID = (
        SELECT
          MAX(TRANSACTION_ID)
        FROM
          JAI_OM_OE_BOND_TRXS
        WHERE TRANSACTION_NAME = CP_TRANSACTION_NAME
          AND ORDER_HEADER_ID = CF_BALANCESFORMULA.ORDER_HEADER_ID
          AND ORDER_FLAG = 'Y' );