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.

[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on EGO_OBJ_AG_ASSOCS_B

Line 8838: FROM EGO_OBJ_AG_ASSOCS_B A, EGO_FND_DSC_FLX_CTX_EXT EXT

8834: AND MSII.SOURCE_SYSTEM_ID = ATTRS.SOURCE_SYSTEM_ID
8835: AND MSII.SOURCE_SYSTEM_REFERENCE = ATTRS.SOURCE_SYSTEM_REFERENCE
8836: AND MSII.ORGANIZATION_ID = l_org_id)
8837: AND EXISTS (SELECT NULL
8838: FROM EGO_OBJ_AG_ASSOCS_B A, EGO_FND_DSC_FLX_CTX_EXT EXT
8839: WHERE A.ATTR_GROUP_ID = EXT.ATTR_GROUP_ID
8840: AND A.OBJECT_ID = (SELECT OBJECT_ID FROM FND_OBJECTS WHERE OBJ_NAME = 'EGO_ITEM')
8841: AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = ATTRS.ATTR_GROUP_INT_NAME
8842: AND EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL(ATTRS.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')

Line 10169: , EGO_OBJ_AG_ASSOCS_B A

10165: AND EIUAI.PROCESS_STATUS IN ( 3,4 )
10166: AND EIUAI.REQUEST_ID = p_request_id
10167: AND EXISTS( SELECT NULL -- SEE DEFINITION OF EGO_OBJ_ATTR_GRP_ASSOCS_V
10168: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
10169: , EGO_OBJ_AG_ASSOCS_B A
10170: WHERE
10171: -- CHECK FOR REVISION LEVEL GROUPS ONLY
10172: A.DATA_LEVEL = 'ITEM_REVISION_LEVEL'
10173: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 10195: , EGO_OBJ_AG_ASSOCS_B A

10191: AND EIUAI.REVISION IS NOT NULL
10192: AND EIUAI.PROCESS_STATUS = 0
10193: AND EXISTS( SELECT NULL -- SEE DEFINITION OF EGO_OBJ_ATTR_GRP_ASSOCS_V
10194: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
10195: , EGO_OBJ_AG_ASSOCS_B A
10196: WHERE
10197: -- CHECK FOR REVISION LEVEL GROUPS ONLY
10198: A.DATA_LEVEL = 'ITEM_REVISION_LEVEL'
10199: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 10245: , EGO_OBJ_AG_ASSOCS_B A

10241: AND EIUAI.PROCESS_STATUS IN ( 3, 4 )
10242: AND EIUAI.REQUEST_ID = p_request_id
10243: AND EXISTS( SELECT NULL -- SEE DEFINITION OF EGO_OBJ_ATTR_GRP_ASSOCS_V
10244: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
10245: , EGO_OBJ_AG_ASSOCS_B A
10246: WHERE
10247: -- CHECK FOR REVISION LEVEL GROUPS ONLY
10248: A.DATA_LEVEL = 'ITEM_REVISION_LEVEL'
10249: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 10271: , EGO_OBJ_AG_ASSOCS_B A

10267: AND EIUAI.REVISION IS NOT NULL
10268: AND EIUAI.PROCESS_STATUS = 1
10269: AND EXISTS( SELECT NULL -- SEE DEFINITION OF EGO_OBJ_ATTR_GRP_ASSOCS_V
10270: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
10271: , EGO_OBJ_AG_ASSOCS_B A
10272: WHERE
10273: -- CHECK FOR REVISION LEVEL GROUPS ONLY
10274: A.DATA_LEVEL = 'ITEM_REVISION_LEVEL'
10275: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 10305: , EGO_OBJ_AG_ASSOCS_B A

10301: AND EIUAI.PROCESS_STATUS IN ( 3, 4 )
10302: AND EIUAI.REQUEST_ID = p_request_id
10303: AND EXISTS( SELECT NULL -- SEE DEFINITION OF EGO_OBJ_ATTR_GRP_ASSOCS_V
10304: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
10305: , EGO_OBJ_AG_ASSOCS_B A
10306: WHERE
10307: -- CHECK FOR REVISION LEVEL GROUPS ONLY
10308: A.DATA_LEVEL = 'ITEM_REVISION_LEVEL'
10309: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 10336: , EGO_OBJ_AG_ASSOCS_B A

10332: AND EIUAI.REVISION IS NOT NULL
10333: AND EIUAI.PROCESS_STATUS = 1
10334: AND EXISTS( SELECT NULL -- SEE DEFINITION OF EGO_OBJ_ATTR_GRP_ASSOCS_V
10335: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
10336: , EGO_OBJ_AG_ASSOCS_B A
10337: WHERE
10338: -- CHECK FOR REVISION LEVEL GROUPS ONLY
10339: A.DATA_LEVEL = 'ITEM_REVISION_LEVEL'
10340: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )