APPS.JA_JAINAR3R_XMLP_PKG SQL Statements

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

Line: 24

      SELECT
        TRX_NUMBER
      FROM
        RA_CUSTOMER_TRX_ALL
      WHERE CUSTOMER_TRX_ID = L_TRX_NUMBER;

Line: 30

      SELECT
        TO_CHAR(ORDER_NUMBER)
      FROM
        OE_ORDER_HEADERS_ALL
      WHERE HEADER_ID = P_ORDER_NUMBER;

Line: 56

    SELECT
      LOCATION
    INTO V_LOCATION
    FROM
      HZ_CUST_SITE_USES_ALL
    WHERE SITE_USE_ID = NVL(CUSTOMER_SITE_ID
       ,0);

Line: 72

      SELECT
        A.NAME
      FROM
        WSH_NEW_DELIVERIES A,
        WSH_DELIVERY_ASSIGNMENTS B
      WHERE A.DELIVERY_ID = B.DELIVERY_ID
        AND B.DELIVERY_DETAIL_ID = P_DELIVERY_DETAIL_ID;

Line: 92

      SELECT
        DELIVERY_ID
      FROM
        WSH_DELIVERY_ASSIGNMENTS B
      WHERE B.DELIVERY_DETAIL_ID = P_DELIVERY_DETAIL_ID;

Line: 112

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