APPS.DOM_DOCUMENT_UTIL dependencies on ENG_LIFECYCLE_STATUSES

Line 39: , eng_lifecycle_statuses lifecycle

35: , stat.status_type
36: , lifecycle.change_wf_route_id
37: , stat.status_name
38: FROM eng_change_statuses_vl stat
39: , eng_lifecycle_statuses lifecycle
40: , dom_document_revisions rev
41: WHERE lifecycle.status_code = stat.status_code
42: AND lifecycle.change_wf_route_id = c_route_id
43: AND lifecycle.entity_id1 = rev.lifecycle_tracking_id

Line 229: FROM eng_change_statuses stat, dom_document_revisions rev, eng_lifecycle_statuses life

225:
226:
227: SELECT rev.lifecycle_phase_id, status_type, life.sequence_number
228: INTO l_status_code, l_status_type, l_seq_num
229: FROM eng_change_statuses stat, dom_document_revisions rev, eng_lifecycle_statuses life
230: WHERE
231: life.status_code = stat.status_code AND
232: stat.status_code = rev.lifecycle_phase_id AND
233: life.entity_id1 = rev.lifecycle_tracking_id AND

Line 259: FROM eng_lifecycle_statuses life,eng_change_statuses_vl stat

255: ELSIF (p_wf_route_status = ENG_WORKFLOW_UTIL.G_RT_COMPLETED) THEN
256:
257: SELECT Count(*)
258: INTO l_row_count
259: FROM eng_lifecycle_statuses life,eng_change_statuses_vl stat
260: WHERE
261: life.status_code = stat.status_code and
262: life.entity_id1 = p_change_id AND
263: stat.status_type = l_status_type AND

Line 287: FROM eng_lifecycle_statuses life,eng_change_statuses_vl stat

283: ELSIF (p_approval_status = 5) THEN
284:
285: SELECT Count(*)
286: INTO l_row_count
287: FROM eng_lifecycle_statuses life,eng_change_statuses_vl stat
288: WHERE
289: life.status_code = stat.status_code and
290: life.entity_id1 = p_change_id AND
291: stat.status_type = l_status_type AND