eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_CREATE_LINES_PKG dependencies on AMW_LATEST_HIERARCHY_RL_V

Line 154: ,AMW_LATEST_HIERARCHY_RL_V APHD

150: ,ALR.DESCRIPTION
151: ,ALR.PROCESS_CODE
152: --,alr.revision_number
153: FROM AMW_LATEST_REVISIONS_V ALR
154: ,AMW_LATEST_HIERARCHY_RL_V APHD
155: WHERE APHD.CHILD_process_ID=ALR.PROCESS_ID
156: AND APHD.parent_PROCESS_ID=p_pk1 --processId
157: minus
158: SELECT ALR.PROCESS_ID

Line 190: ,AMW_LATEST_HIERARCHY_RL_V APHD

186: ,ALR.DESCRIPTION
187: ,ALR.PROCESS_CODE
188: --,alr.revision_number
189: FROM AMW_LATEST_REVISIONS_V ALR
190: ,AMW_LATEST_HIERARCHY_RL_V APHD
191: WHERE APHD.CHILD_process_ID=ALR.PROCESS_ID
192: AND APHD.parent_PROCESS_ID=p_pk1; --processId
193:
194: ---02.16.2004 npanandi: cursor to get risks for AddRisk lineType