APPS.MTL_RELATED_ITEMS_PKG1 SQL Statements

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

Line: 14

   select raa.address1
   into address_name
   from ra_addresses_all raa,
        ra_site_uses_all rasu
   where  rasu.site_use_id = X_site_id
     and  raa.address_id = rasu.address_id; */

Line: 21

     SELECT LOC.ADDRESS1
     INTO ADDRESS_NAME
     FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
          HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE , HZ_CUST_SITE_USES_ALL SITE_USER
     WHERE SITE_USER.SITE_USE_ID = X_site_id
       AND ACCT_SITE.CUST_ACCT_SITE_ID = SITE_USER.CUST_ACCT_SITE_ID
       AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
       AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
       AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
       AND NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99)
       AND NVL(SITE_USER.ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB( USERENV('CLIENT_INFO'),1,1),' ', NULL,
                                                     SUBSTRB( USERENV('CLIENT_INFO'),1,10))),-99)) =
                                NVL(TO_NUMBER(DECODE(SUBSTRB( USERENV('CLIENT_INFO'),1,1),' ', NULL,
				                     SUBSTRB( USERENV( 'CLIENT_INFO'),1,10))),-99);