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.EGO_IMPORT_PVT dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 850: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

846: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
847: )
848: rnk
849: , eiuai.*
850: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
851: WHERE DATA_SET_ID = p_batch_id
852: AND PROCESS_STATUS = 1
853: AND ITEM_NUMBER IS NOT NULL
854: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 935: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

931: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
932: )
933: rnk
934: , eiuai.*
935: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
936: WHERE DATA_SET_ID = p_batch_id
937: AND PROCESS_STATUS = 0
938: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
939: AND FL_CTX_EXT.APPLICATION_ID = 431

Line 1272: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

1268: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1269: )
1270: rnk
1271: , eiuai.*
1272: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
1273: WHERE DATA_SET_ID = p_batch_id
1274: AND PROCESS_STATUS = 1
1275: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1276: AND FL_CTX_EXT.APPLICATION_ID = 431

Line 1351: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

1347: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1348: )
1349: rnk
1350: , eiuai.*
1351: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
1352: WHERE DATA_SET_ID = p_batch_id
1353: AND PROCESS_STATUS = 0
1354: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1355: AND FL_CTX_EXT.APPLICATION_ID = 431

Line 4305: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

4301: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
4302: )
4303: rnk
4304: , eiuai.*
4305: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
4306: WHERE DATA_SET_ID = p_batch_id
4307: AND PROCESS_STATUS = 1
4308: AND ITEM_NUMBER IS NOT NULL
4309: AND ORGANIZATION_ID IS NOT NULL

Line 4620: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

4616: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
4617: )
4618: rnk
4619: , eiuai.*
4620: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
4621: WHERE DATA_SET_ID = p_batch_id
4622: AND PROCESS_STATUS = 1
4623: AND ITEM_NUMBER IS NOT NULL
4624: AND ORGANIZATION_ID IS NOT NULL

Line 6595: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

6591: -- put that data level id here. --
6592: -----------------------------------------------------------
6593: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
6594: SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID
6595: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
6596: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
6597: AND ag_ext.APPLICATION_ID = 431
6598: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
6599: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME

Line 6607: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

6603: AND uai.DATA_LEVEL_ID IS NULL
6604: AND uai.DATA_LEVEL_NAME IS NULL
6605: AND uai.USER_DATA_LEVEL_NAME IS NULL
6606: AND (SELECT COUNT(*)
6607: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
6608: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
6609: AND ag_ext.APPLICATION_ID = 431
6610: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
6611: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME

Line 7438: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

7434: AND PROCESS_STATUS = p_process_status
7435: AND (ITEM_NUMBER IS NOT NULL OR SOURCE_SYSTEM_REFERENCE IS NOT NULL)
7436: AND DATA_LEVEL_ID IS NOT NULL
7437: AND EXISTS( SELECT NULL
7438: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
7439: WHERE FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7440: AND FL_CTX_EXT.APPLICATION_ID = 431
7441: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = eiuai.ATTR_GROUP_INT_NAME
7442: AND FL_CTX_EXT.MULTI_ROW = 'N'

Line 7485: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

7481: AND PROCESS_STATUS = p_process_status
7482: AND (ITEM_NUMBER IS NOT NULL OR SOURCE_SYSTEM_REFERENCE IS NOT NULL)
7483: AND DATA_LEVEL_ID IS NOT NULL
7484: AND EXISTS( SELECT NULL
7485: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
7486: WHERE FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7487: AND FL_CTX_EXT.APPLICATION_ID = 431
7488: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = eiuai.ATTR_GROUP_INT_NAME
7489: AND FL_CTX_EXT.MULTI_ROW = 'N'

Line 7668: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

7664: AND PROCESS_STATUS = p_process_status
7665: AND INVENTORY_ITEM_ID IS NOT NULL
7666: AND DATA_LEVEL_ID IS NOT NULL
7667: AND EXISTS( SELECT NULL
7668: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
7669: WHERE FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7670: AND FL_CTX_EXT.APPLICATION_ID = 431
7671: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = eiuai.ATTR_GROUP_INT_NAME
7672: AND FL_CTX_EXT.MULTI_ROW = 'N'

Line 7713: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

7709: AND PROCESS_STATUS = p_process_status
7710: AND INVENTORY_ITEM_ID IS NOT NULL
7711: AND DATA_LEVEL_ID IS NOT NULL
7712: AND EXISTS( SELECT NULL
7713: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
7714: WHERE FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7715: AND FL_CTX_EXT.APPLICATION_ID = 431
7716: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = eiuai.ATTR_GROUP_INT_NAME
7717: AND FL_CTX_EXT.MULTI_ROW = 'N'

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 10065: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

10061: AND EIUAI.REVISION IS NOT NULL
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'

Line 10091: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

10087: AND EIUAI.DATA_SET_ID = p_batch_id
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'

Line 10141: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

10137: AND EIUAI.REVISION IS NOT NULL
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'

Line 10167: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

10163: AND EIUAI.DATA_SET_ID = p_batch_id
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'

Line 10201: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

10197: AND EIUAI.REVISION IS NOT NULL
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'

Line 10232: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

10228: AND EIUAI.DATA_SET_ID = p_batch_id
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'