Could you please explain ?

[srinivasm]

HI,

Could you please explain me the bold lines from the following query?

select
lms_user.userid userid,
lms_user.lastname lastname,
lms_user.firstname firstname,
lms_user.registeredname userregname,
lms_user.emailaddress useremail,
lms_user.status status,
lms_user.objectcreateddate objectcreateddate,
lms_user.objectmodifieddate objectmodifieddate,
lms_userext.column01 column01,
lms_userext.column02 column02,
lms_userext.column03 column03,
lms_listofvalues.value statusValue,
lms_subdomain.subdomainid subdomainid,
lms_subdomain.registeredname sdregname,
lms_jobcode.registeredname jobcoderegname ,
lms_jobcode.title jobcodetitle
from
lms_user,
lms_sd_user,
lms_subdomain,
lms_listofvalues,
lms_userext,
lms_jobcodeuser,
lms_jobcode
where
lms_user.status=lms_listofvalues.listofvaluesid
and
lms_listofvalues.value=:"SYS_B_00"
and
lms_userext.userid = lms_user.userid
and
lms_userext.column16 >= :"SYS_B_01"
and
lms_userext.column16 <= :"SYS_B_02"
and
( (
upper(lms_user.firstname) like :"SYS_B_03" ESCAPE :"SYS_B_04"
and
upper(lms_user.lastname) like :"SYS_B_05" ESCAPE :"SYS_B_06"
and
upper(lms_user.emailaddress) like :"SYS_B_07" ESCAPE :"SYS_B_08"
and
upper(lms_user.registeredname) like :"SYS_B_09" escape :"SYS_B_10"
)
)
and
lms_user.accountid = :"SYS_B_11"
and
lms_sd_user.userid = lms_user.userid
and
lms_sd_user.subdomainid in (:"SYS_B_12")
and
lms_subdomain.subdomainid = lms_sd_user.subdomainid
and
lms_jobcodeuser.userid(+) = lms_user.userid
and
lms_jobcode.jobcodeid (+)= lms_jobcodeuser.jobcodeid
and
rownum <= :"SYS_B_13"


Thanks in advance,
Srinivas Medukonduru

[jmodic]

Bind variables....