DBA Data[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on EGO_OBJ_AG_ASSOCS_B

Line 8735: FROM EGO_OBJ_AG_ASSOCS_B A, EGO_FND_DSC_FLX_CTX_EXT EXT

8731: AND MSII.SOURCE_SYSTEM_ID = ATTRS.SOURCE_SYSTEM_ID
8732: AND MSII.SOURCE_SYSTEM_REFERENCE = ATTRS.SOURCE_SYSTEM_REFERENCE
8733: AND MSII.ORGANIZATION_ID = l_org_id)
8734: AND EXISTS (SELECT NULL
8735: FROM EGO_OBJ_AG_ASSOCS_B A, EGO_FND_DSC_FLX_CTX_EXT EXT
8736: WHERE A.ATTR_GROUP_ID = EXT.ATTR_GROUP_ID
8737: AND A.OBJECT_ID = (SELECT OBJECT_ID FROM FND_OBJECTS WHERE OBJ_NAME = 'EGO_ITEM')
8738: AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = ATTRS.ATTR_GROUP_INT_NAME
8739: AND EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL(ATTRS.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')

Line 10066: , EGO_OBJ_AG_ASSOCS_B A

10062: AND EIUAI.PROCESS_STATUS IN ( 3,4 )
10063: AND EIUAI.REQUEST_ID = p_request_id
10064: AND EXISTS( SELECT NULL -- SEE DEFINITION OF EGO_OBJ_ATTR_GRP_ASSOCS_V
10065: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
10066: , EGO_OBJ_AG_ASSOCS_B A
10067: WHERE
10068: -- CHECK FOR REVISION LEVEL GROUPS ONLY
10069: A.DATA_LEVEL = 'ITEM_REVISION_LEVEL'
10070: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 10092: , EGO_OBJ_AG_ASSOCS_B A

10088: AND EIUAI.REVISION IS NOT NULL
10089: AND EIUAI.PROCESS_STATUS = 0
10090: AND EXISTS( SELECT NULL -- SEE DEFINITION OF EGO_OBJ_ATTR_GRP_ASSOCS_V
10091: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
10092: , EGO_OBJ_AG_ASSOCS_B A
10093: WHERE
10094: -- CHECK FOR REVISION LEVEL GROUPS ONLY
10095: A.DATA_LEVEL = 'ITEM_REVISION_LEVEL'
10096: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 10142: , EGO_OBJ_AG_ASSOCS_B A

10138: AND EIUAI.PROCESS_STATUS IN ( 3, 4 )
10139: AND EIUAI.REQUEST_ID = p_request_id
10140: AND EXISTS( SELECT NULL -- SEE DEFINITION OF EGO_OBJ_ATTR_GRP_ASSOCS_V
10141: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
10142: , EGO_OBJ_AG_ASSOCS_B A
10143: WHERE
10144: -- CHECK FOR REVISION LEVEL GROUPS ONLY
10145: A.DATA_LEVEL = 'ITEM_REVISION_LEVEL'
10146: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 10168: , EGO_OBJ_AG_ASSOCS_B A

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

Line 10202: , EGO_OBJ_AG_ASSOCS_B A

10198: AND EIUAI.PROCESS_STATUS IN ( 3, 4 )
10199: AND EIUAI.REQUEST_ID = p_request_id
10200: AND EXISTS( SELECT NULL -- SEE DEFINITION OF EGO_OBJ_ATTR_GRP_ASSOCS_V
10201: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
10202: , EGO_OBJ_AG_ASSOCS_B A
10203: WHERE
10204: -- CHECK FOR REVISION LEVEL GROUPS ONLY
10205: A.DATA_LEVEL = 'ITEM_REVISION_LEVEL'
10206: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 10233: , EGO_OBJ_AG_ASSOCS_B A

10229: AND EIUAI.REVISION IS NOT NULL
10230: AND EIUAI.PROCESS_STATUS = 1
10231: AND EXISTS( SELECT NULL -- SEE DEFINITION OF EGO_OBJ_ATTR_GRP_ASSOCS_V
10232: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
10233: , EGO_OBJ_AG_ASSOCS_B A
10234: WHERE
10235: -- CHECK FOR REVISION LEVEL GROUPS ONLY
10236: A.DATA_LEVEL = 'ITEM_REVISION_LEVEL'
10237: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )