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.ENG_WORKFLOW_UTIL dependencies on ENG_CHANGE_SUBJECTS

Line 3226: FROM ENG_CHANGE_SUBJECTS subject

3222:
3223: SELECT TO_NUMBER(subject.pk2_value) organization_id
3224: , TO_NUMBER(subject.pk1_value) item_id
3225: , TO_NUMBER(subject.pk3_value) item_revision_id
3226: FROM ENG_CHANGE_SUBJECTS subject
3227: WHERE subject.pk1_value IS NOT NULL
3228: AND subject.pk2_value IS NOT NULL
3229: AND subject.entity_name = p_entity_name
3230: AND subject.change_line_id IS NULL

Line 3313: FROM ENG_CHANGE_SUBJECTS subject

3309:
3310: SELECT TO_NUMBER(subject.pk2_value) organization_id
3311: , TO_NUMBER(subject.pk1_value) item_id
3312: , TO_NUMBER(subject.pk3_value) item_revision_id
3313: FROM ENG_CHANGE_SUBJECTS subject
3314: WHERE subject.pk1_value IS NOT NULL
3315: AND subject.pk2_value IS NOT NULL
3316: AND subject.entity_name = p_entity_name
3317: AND subject.change_line_id = p_change_line_id

Line 13690: FROM ENG_CHANGE_SUBJECTS ChangeSubj

13686: , ChangeSubj.PK4_VALUE
13687: , ChangeSubj.PK5_VALUE
13688: , ChangeSubj.CHANGE_ID
13689: , ChangeSubj.CHANGE_LINE_ID
13690: FROM ENG_CHANGE_SUBJECTS ChangeSubj
13691: , FND_OBJECTS FndObj
13692: WHERE ChangeSubj.ENTITY_NAME = FndObj.OBJ_NAME
13693: AND ChangeSubj.CHANGE_ID = c_change_id
13694: AND ( ChangeSubj.CHANGE_LINE_ID = c_change_line_id

Line 13712: -- FROM ENG_CHANGE_SUBJECTS ChangeCompSubj

13708: -- , ChangeCompSubj.PK4_VALUE
13709: -- , ChangeCompSubj.PK5_VALUE
13710: -- , ChangeCompSubj.CHANGE_ID
13711: -- , ChangeCompSubj.CHANGE_LINE_ID
13712: -- FROM ENG_CHANGE_SUBJECTS ChangeCompSubj
13713: -- WHERE ChangeCompSubj.ENTITY_NAME = 'EGO_COMPONENT'
13714: -- AND ChangeCompSubj.CHANGE_ID = :c_change_id
13715: -- AND ( ChangeCompSubj.CHANGE_LINE_ID = :c_change_line_id
13716: -- OR ( ChangeCompSubj.CHANGE_LINE_ID IS NULL

Line 14646: FROM ENG_CHANGE_SUBJECTS ChangeSubj

14642: , ChangeSubj.PK4_VALUE
14643: , ChangeSubj.PK5_VALUE
14644: , ChangeSubj.CHANGE_ID
14645: , ChangeSubj.CHANGE_LINE_ID
14646: FROM ENG_CHANGE_SUBJECTS ChangeSubj
14647: , FND_OBJECTS FndObj
14648: WHERE ChangeSubj.ENTITY_NAME = FndObj.OBJ_NAME
14649: AND ChangeSubj.CHANGE_ID = c_change_id
14650: AND ( ChangeSubj.CHANGE_LINE_ID = c_change_line_id

Line 14668: -- FROM ENG_CHANGE_SUBJECTS ChangeCompSubj

14664: -- , ChangeCompSubj.PK4_VALUE
14665: -- , ChangeCompSubj.PK5_VALUE
14666: -- , ChangeCompSubj.CHANGE_ID
14667: -- , ChangeCompSubj.CHANGE_LINE_ID
14668: -- FROM ENG_CHANGE_SUBJECTS ChangeCompSubj
14669: -- WHERE ChangeCompSubj.ENTITY_NAME = 'EGO_COMPONENT'
14670: -- AND ChangeCompSubj.CHANGE_ID = :c_change_id
14671: -- AND ( ChangeCompSubj.CHANGE_LINE_ID = :c_change_line_id
14672: -- OR ( ChangeCompSubj.CHANGE_LINE_ID IS NULL