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 13663: , FND_OBJECTS fnd_obj

13659: , fnd_obj.OBJ_NAME ORIG_ROLE_OBJECT_NAME
13660: , fnd_obj.OBJECT_ID ORIG_ROLE_OBJECT_ID
13661: FROM FND_FORM_FUNCTIONS fnd_func
13662: , FND_MENU_ENTRIES fnd_menu
13663: , FND_OBJECTS fnd_obj
13664: , ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13665: WHERE fnd_obj.OBJECT_ID = fnd_func.OBJECT_ID
13666: AND fnd_func.FUNCTION_ID = fnd_menu.FUNCTION_ID
13667: AND fnd_menu.MENU_ID = ORIGINAL_ASSIGNEE_ID

Line 13691: , FND_OBJECTS FndObj

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
13695: OR (ChangeSubj.CHANGE_LINE_ID IS NULL

Line 14619: , FND_OBJECTS fnd_obj

14615: , fnd_obj.OBJ_NAME ORIG_ROLE_OBJECT_NAME
14616: , fnd_obj.OBJECT_ID ORIG_ROLE_OBJECT_ID
14617: FROM FND_FORM_FUNCTIONS fnd_func
14618: , FND_MENU_ENTRIES fnd_menu
14619: , FND_OBJECTS fnd_obj
14620: , ENG_CHANGE_ROUTE_PEOPLE RoutePeople
14621: , ENG_CHANGE_ROUTE_STEPS RouteStep
14622: WHERE fnd_obj.OBJECT_ID = fnd_func.OBJECT_ID
14623: AND fnd_func.FUNCTION_ID = fnd_menu.FUNCTION_ID

Line 14647: , FND_OBJECTS FndObj

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
14651: OR (ChangeSubj.CHANGE_LINE_ID IS NULL