DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_UTIL dependencies on FND_OBJECTS

Line 3215: -- , FND_OBJECTS obj

3211: -- SELECT TO_NUMBER(subject.pk2_value) organization_id
3212: -- , TO_NUMBER(subject.pk1_value) item_id
3213: -- , TO_NUMBER(subject.pk3_value) item_revision_id
3214: -- FROM ENG_CHANGE_LINES subject
3215: -- , FND_OBJECTS obj
3216: -- WHERE subject.pk1_value IS NOT NULL
3217: -- AND subject.pk2_value IS NOT NULL
3218: -- AND subject.sequence_number = -1
3219: -- AND subject.object_id = obj.object_id

Line 3303: -- , FND_OBJECTS obj

3299: -- SELECT TO_NUMBER(subject.pk2_value) organization_id
3300: -- , TO_NUMBER(subject.pk1_value) item_id
3301: -- , TO_NUMBER(subject.pk3_value) item_revision_id
3302: -- FROM ENG_CHANGE_LINES subject
3303: -- , FND_OBJECTS obj
3304: -- WHERE subject.pk1_value IS NOT NULL
3305: -- AND subject.pk2_value IS NOT NULL
3306: -- AND subject.object_id = obj.object_id
3307: -- AND obj.obj_name IN ('EGO_ITEM', 'EGO_ITEM_REVISION')

Line 13808: , FND_OBJECTS fnd_obj

13804: , fnd_obj.OBJ_NAME ORIG_ROLE_OBJECT_NAME
13805: , fnd_obj.OBJECT_ID ORIG_ROLE_OBJECT_ID
13806: FROM FND_FORM_FUNCTIONS fnd_func
13807: , FND_MENU_ENTRIES fnd_menu
13808: , FND_OBJECTS fnd_obj
13809: , ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13810: WHERE fnd_obj.OBJECT_ID = fnd_func.OBJECT_ID
13811: AND fnd_func.FUNCTION_ID = fnd_menu.FUNCTION_ID
13812: AND fnd_menu.MENU_ID = ORIGINAL_ASSIGNEE_ID

Line 13836: , FND_OBJECTS FndObj

13832: , ChangeSubj.PK5_VALUE
13833: , ChangeSubj.CHANGE_ID
13834: , ChangeSubj.CHANGE_LINE_ID
13835: FROM ENG_CHANGE_SUBJECTS ChangeSubj
13836: , FND_OBJECTS FndObj
13837: WHERE ChangeSubj.ENTITY_NAME = FndObj.OBJ_NAME
13838: AND ChangeSubj.CHANGE_ID = c_change_id
13839: AND ( ChangeSubj.CHANGE_LINE_ID = c_change_line_id
13840: OR (ChangeSubj.CHANGE_LINE_ID IS NULL

Line 14764: , FND_OBJECTS fnd_obj

14760: , fnd_obj.OBJ_NAME ORIG_ROLE_OBJECT_NAME
14761: , fnd_obj.OBJECT_ID ORIG_ROLE_OBJECT_ID
14762: FROM FND_FORM_FUNCTIONS fnd_func
14763: , FND_MENU_ENTRIES fnd_menu
14764: , FND_OBJECTS fnd_obj
14765: , ENG_CHANGE_ROUTE_PEOPLE RoutePeople
14766: , ENG_CHANGE_ROUTE_STEPS RouteStep
14767: WHERE fnd_obj.OBJECT_ID = fnd_func.OBJECT_ID
14768: AND fnd_func.FUNCTION_ID = fnd_menu.FUNCTION_ID

Line 14792: , FND_OBJECTS FndObj

14788: , ChangeSubj.PK5_VALUE
14789: , ChangeSubj.CHANGE_ID
14790: , ChangeSubj.CHANGE_LINE_ID
14791: FROM ENG_CHANGE_SUBJECTS ChangeSubj
14792: , FND_OBJECTS FndObj
14793: WHERE ChangeSubj.ENTITY_NAME = FndObj.OBJ_NAME
14794: AND ChangeSubj.CHANGE_ID = c_change_id
14795: AND ( ChangeSubj.CHANGE_LINE_ID = c_change_line_id
14796: OR (ChangeSubj.CHANGE_LINE_ID IS NULL