DBA Data[Home] [Help]

APPS.DOM_DOCUMENT_UTIL dependencies on ENG_CHANGE_STATUSES_VL

Line 38: FROM eng_change_statuses_vl stat

34: , lifecycle.status_code
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

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