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 865: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

861: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
862: )
863: rnk
864: , eiuai.*
865: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
866: WHERE DATA_SET_ID = p_batch_id
867: AND PROCESS_STATUS = 1
868: AND ITEM_NUMBER IS NOT NULL
869: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 950: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

946: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
947: )
948: rnk
949: , eiuai.*
950: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
951: WHERE DATA_SET_ID = p_batch_id
952: AND PROCESS_STATUS = 0
953: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
954: AND FL_CTX_EXT.APPLICATION_ID = 431

Line 1287: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

1283: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1284: )
1285: rnk
1286: , eiuai.*
1287: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
1288: WHERE DATA_SET_ID = p_batch_id
1289: AND PROCESS_STATUS = 1
1290: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1291: AND FL_CTX_EXT.APPLICATION_ID = 431

Line 1369: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

1365: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1366: )
1367: rnk
1368: , eiuai.*
1369: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
1370: WHERE DATA_SET_ID = p_batch_id
1371: AND PROCESS_STATUS = 0
1372: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1373: AND FL_CTX_EXT.APPLICATION_ID = 431

Line 4367: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

4363: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
4364: )
4365: rnk
4366: , eiuai.*
4367: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
4368: WHERE DATA_SET_ID = p_batch_id
4369: AND PROCESS_STATUS = 1
4370: AND ITEM_NUMBER IS NOT NULL
4371: AND ORGANIZATION_ID IS NOT NULL

Line 4685: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

4681: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
4682: )
4683: rnk
4684: , eiuai.*
4685: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
4686: WHERE DATA_SET_ID = p_batch_id
4687: AND PROCESS_STATUS = 1
4688: AND ITEM_NUMBER IS NOT NULL
4689: AND ORGANIZATION_ID IS NOT NULL

Line 6677: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

6673: -- put that data level id here. --
6674: -----------------------------------------------------------
6675: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
6676: SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID
6677: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
6678: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
6679: AND ag_ext.APPLICATION_ID = 431
6680: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
6681: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME

Line 6689: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

6685: AND uai.DATA_LEVEL_ID IS NULL
6686: AND uai.DATA_LEVEL_NAME IS NULL
6687: AND uai.USER_DATA_LEVEL_NAME IS NULL
6688: AND (SELECT COUNT(*)
6689: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
6690: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
6691: AND ag_ext.APPLICATION_ID = 431
6692: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
6693: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME

Line 7533: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

7529: AND PROCESS_STATUS = p_process_status
7530: AND (ITEM_NUMBER IS NOT NULL OR SOURCE_SYSTEM_REFERENCE IS NOT NULL)
7531: AND DATA_LEVEL_ID IS NOT NULL
7532: AND EXISTS( SELECT NULL
7533: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
7534: WHERE FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7535: AND FL_CTX_EXT.APPLICATION_ID = 431
7536: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = eiuai.ATTR_GROUP_INT_NAME
7537: AND FL_CTX_EXT.MULTI_ROW = 'N'

Line 7581: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

7577: AND PROCESS_STATUS = p_process_status
7578: AND (ITEM_NUMBER IS NOT NULL OR SOURCE_SYSTEM_REFERENCE IS NOT NULL)
7579: AND DATA_LEVEL_ID IS NOT NULL
7580: AND EXISTS( SELECT NULL
7581: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
7582: WHERE FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7583: AND FL_CTX_EXT.APPLICATION_ID = 431
7584: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = eiuai.ATTR_GROUP_INT_NAME
7585: AND FL_CTX_EXT.MULTI_ROW = 'N'

Line 7767: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

7763: AND PROCESS_STATUS = p_process_status
7764: AND INVENTORY_ITEM_ID IS NOT NULL
7765: AND DATA_LEVEL_ID IS NOT NULL
7766: AND EXISTS( SELECT NULL
7767: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
7768: WHERE FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7769: AND FL_CTX_EXT.APPLICATION_ID = 431
7770: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = eiuai.ATTR_GROUP_INT_NAME
7771: AND FL_CTX_EXT.MULTI_ROW = 'N'

Line 7813: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

7809: AND PROCESS_STATUS = p_process_status
7810: AND INVENTORY_ITEM_ID IS NOT NULL
7811: AND DATA_LEVEL_ID IS NOT NULL
7812: AND EXISTS( SELECT NULL
7813: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
7814: WHERE FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7815: AND FL_CTX_EXT.APPLICATION_ID = 431
7816: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = eiuai.ATTR_GROUP_INT_NAME
7817: AND FL_CTX_EXT.MULTI_ROW = 'N'

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

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

Line 10194: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

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

Line 10244: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

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

Line 10270: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

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

Line 10304: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

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

Line 10335: FROM EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

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