AnsweredAssumed Answered

Need help with NSQL

Question asked by hwk on Jul 24, 2013
Latest reply on Jul 24, 2013 by hwk
Hello everyone,

I am trying to find out from which table a particular filed is read from in the following NSQL.
The column name as mentioned in this NSQL is - x_in_service@. I am trying hard to figure out from which particular table this field is from.

Can someone please guide how to identify the table name for the fields.
My understanding is the table name needs to be mentioned before the column name - as done in case of full_name = r4.full_name:prsponsoredbyName@,
but there is no table name prefix for x_in_service

Do I need to check each of the table listed in this NSQL?
Urgent help needed.


Select
@SELECT:DIM:USER_DEF:IMPLIED:ALERTS:i.code:project_code@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:ALERTS:i.name:name@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:ALERTS:x_exec_cat_luf:x_exec_cat_luf@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:ALERTS:x_in_service:x_in_service@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:ALERTS:x_const_start_dt:x_const_start_dt@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:ALERTS:prsponsoredby:prsponsoredby@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:ALERTS:r4.full_name:prsponsoredbyName@,


From

(
Select distinct pfc.invest_id
from pma_portfolios pf
,PMA_PORTFOLIO_CONTENTS pfc
Where pf.id = pfc.PORTFOLIO_ID and pfc.INVEST_TYPE = 'project'
and (pf.unique_name = @WHERE:PARAM:USER_DEF:STRING:PORTFOLIO_CODE@ or @WHERE:PARAM:USER_DEF:STRING:PORTFOLIO_CODE@ is null)
) port_itns

,


inv_investments i, odf_ca_project p , prj_projects pj
, srm_resources r1 , srm_resources r2 , srm_resources r3 , srm_resources r4
, srm_resources r5 , srm_resources r6
, odf_ca_x_trans_materials mat

where p.id = i.id and i.id = pj.prid and cp.id(+) = i.id and i.id = par2.odf_parent_id(+)
and i.id = mat.odf_parent_id(+)

and Port_itns.invest_id = i.id

and x_trans_related = 1
and r1.id(+) = p.x_exec_cat_mgr
and r2.id(+) = p.x_itn_owner
and r3.id(+) = p.x_itn_requestor_luf
and r4.id(+) = pj.prsponsoredby

and r5.id(+) = p.x_pm_pcm_cst_eng_luf
and r6.id(+) = p.x_pcm_lead_sched_luf


AND @FILTER@

Outcomes