APPS.AMW_CREATE_LINES_PKG dependencies on AMW_LATEST_REVISIONS_V

Line 153: FROM AMW_LATEST_REVISIONS_V ALR

149: ,ALR.DISPLAY_NAME
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

Line 164: FROM AMW_LATEST_REVISIONS_V ALR

160: ,ALR.DISPLAY_NAME
161: ,ALR.DESCRIPTION
162: ,ALR.PROCESS_CODE
163: --,alr.revision_number
164: FROM AMW_LATEST_REVISIONS_V ALR
165: ,AMW_CURR_APP_HIERARCHY_RL_V APHD
166: WHERE APHD.CHILD_process_ID=ALR.PROCESS_ID
167: AND APHD.parent_PROCESS_ID=p_pk1; --processId
168:

Line 178: FROM AMW_LATEST_REVISIONS_V ALR

174: ,ALR.DISPLAY_NAME
175: ,ALR.DESCRIPTION
176: ,ALR.PROCESS_CODE
177: --,alr.revision_number
178: FROM AMW_LATEST_REVISIONS_V ALR
179: ,AMW_CURR_APP_HIERARCHY_RL_V APHD
180: WHERE APHD.CHILD_process_ID=ALR.PROCESS_ID
181: AND APHD.parent_PROCESS_ID=p_pk1 --processId
182: minus

Line 189: FROM AMW_LATEST_REVISIONS_V ALR

185: ,ALR.DISPLAY_NAME
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:

Line 406: from amw_latest_revisions_v

402: ---there may be an immediate child Process, which is also in Draft status
403: ---in this case, the AddProcess Cursor's 'minus' clause causes problems in
404: ---revisionNumber data, and incorrect resultSet is obtained.
405: select revision_number into l_revision_number
406: from amw_latest_revisions_v
407: where process_id=add_proc_rec.process_id;
408:
409: process_lines(
410: p_change_id => p_change_id