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_GTIN_PVT dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 1614: FROM EGO_FND_DSC_FLX_CTX_EXT

1610: write_debug_log('Item ID , Org ID, Attr_Group_Name = '||p_inventory_item_id||','||p_organization_id||','||p_attr_group_name);
1611:
1612: BEGIN
1613: SELECT AGV_NAME, ATTR_GROUP_ID INTO l_view_name, l_attr_group_id
1614: FROM EGO_FND_DSC_FLX_CTX_EXT
1615: WHERE DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_ITEM_TP_EXT_ATTRS'
1616: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
1617: AND APPLICATION_ID = 431;
1618: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2879: EGO_FND_DSC_FLX_CTX_EXT EXT

2875:
2876: SELECT 'X' into l_temp
2877: FROM
2878: EGO_OBJ_AG_ASSOCS_B A,
2879: EGO_FND_DSC_FLX_CTX_EXT EXT
2880: WHERE
2881: A.ATTR_GROUP_ID = EXT.ATTR_GROUP_ID
2882: AND EXT.APPLICATION_ID = p_application_id
2883: and EXT.DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type

Line 2910: TYPE t_AttrGroupNameTbl IS TABLE OF EGO_FND_DSC_FLX_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE INDEX BY BINARY_INTEGER;

2906: IS
2907:
2908: TYPE t_NumberTbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2909: TYPE t_PageNameTbl IS TABLE OF EGO_PAGES_TL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER;
2910: TYPE t_AttrGroupNameTbl IS TABLE OF EGO_FND_DSC_FLX_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE INDEX BY BINARY_INTEGER;
2911: TYPE t_AttrGroupTypeTbl IS TABLE OF EGO_FND_DSC_FLX_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME%TYPE INDEX BY BINARY_INTEGER;
2912:
2913: -- CONSTANTS
2914: G_EGO_APP_ID CONSTANT NUMBER := 431;

Line 2911: TYPE t_AttrGroupTypeTbl IS TABLE OF EGO_FND_DSC_FLX_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME%TYPE INDEX BY BINARY_INTEGER;

2907:
2908: TYPE t_NumberTbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2909: TYPE t_PageNameTbl IS TABLE OF EGO_PAGES_TL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER;
2910: TYPE t_AttrGroupNameTbl IS TABLE OF EGO_FND_DSC_FLX_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE INDEX BY BINARY_INTEGER;
2911: TYPE t_AttrGroupTypeTbl IS TABLE OF EGO_FND_DSC_FLX_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME%TYPE INDEX BY BINARY_INTEGER;
2912:
2913: -- CONSTANTS
2914: G_EGO_APP_ID CONSTANT NUMBER := 431;
2915: G_ITEM_OBJECT_NAME CONSTANT VARCHAR2(30) := 'EGO_ITEM';

Line 2979: from EGO_FND_DSC_FLX_CTX_EXT ext,

2975: BEGIN
2976: --dbms_output.put_line('in run11 ');
2977: select 1
2978: into l_zeroeth_assoc_exists
2979: from EGO_FND_DSC_FLX_CTX_EXT ext,
2980: EGO_OBJ_AG_ASSOCS_B assocs
2981: where assocs.classification_code = '-1'
2982: and assocs.object_id = (select object_id from fnd_objects where obj_name = 'EGO_ITEM')
2983: and assocs.attr_group_id =ext.attr_group_id

Line 3197: FROM EGO_FND_DSC_FLX_CTX_EXT

3193: -- Since same attribute group names are used for all catalog groups fetch it before
3194: -- looping through catalog groups.
3195: SELECT ATTR_GROUP_ID, DESCRIPTIVE_FLEX_CONTEXT_CODE, DESCRIPTIVE_FLEXFIELD_NAME
3196: BULK COLLECT INTO l_TmpAttrGrpIds, l_TmpAttrGrpNames, l_TmpAttrGrpTypes
3197: FROM EGO_FND_DSC_FLX_CTX_EXT
3198: -- Attribute Group Type
3199: WHERE DESCRIPTIVE_FLEXFIELD_NAME in ('EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS')
3200: AND application_id = G_EGO_APP_ID
3201: -- Attribute Group Name

Line 3432: and ATTR_GROUP_ID in (SELECT ATTR_GROUP_ID FROM EGO_FND_DSC_FLX_CTX_EXT

3428: BULK COLLECT INTO l_AssocIds --, l_AttrGroupIds
3429: FROM EGO_OBJ_AG_ASSOCS_B
3430: WHERE OBJECT_ID = l_object_id
3431: AND CLASSIFICATION_CODE = l_classification_code
3432: and ATTR_GROUP_ID in (SELECT ATTR_GROUP_ID FROM EGO_FND_DSC_FLX_CTX_EXT
3433: WHERE DESCRIPTIVE_FLEXFIELD_NAME in ('EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS')
3434: AND application_id = G_EGO_APP_ID
3435: AND DESCRIPTIVE_FLEX_CONTEXT_CODE IN
3436: ( 'Trade_Item_Description'

Line 3642: FROM EGO_FND_DSC_FLX_CTX_EXT EXT, EGO_OBJ_AG_ASSOCS_B ASOC, EGO_PAGE_ENTRIES_B PGE, EGO_PAGES_TL PT

3638: l_page_disp_name VARCHAR2(4000);
3639: BEGIN
3640: SELECT PT.PAGE_ID, PT.DISPLAY_NAME
3641: INTO l_page_id, l_page_disp_name
3642: FROM EGO_FND_DSC_FLX_CTX_EXT EXT, EGO_OBJ_AG_ASSOCS_B ASOC, EGO_PAGE_ENTRIES_B PGE, EGO_PAGES_TL PT
3643: WHERE EXT.ATTR_GROUP_ID = ASOC.ATTR_GROUP_ID
3644: AND EXT.APPLICATION_ID = 431
3645: AND EXT.DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
3646: AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name

Line 5118: FROM EGO_FND_DSC_FLX_CTX_EXT AG, EGO_ATTRS_V EAV

5114: DELETE FROM EGO_ITM_GTN_MUL_ATTRS_B
5115: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
5116: AND ORGANIZATION_ID = p_organization_id
5117: AND ATTR_GROUP_ID IN (SELECT AG.ATTR_GROUP_ID
5118: FROM EGO_FND_DSC_FLX_CTX_EXT AG, EGO_ATTRS_V EAV
5119: WHERE AG.APPLICATION_ID = 431
5120: AND EAV.APPLICATION_ID = AG.APPLICATION_ID
5121: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = EAV.ATTR_GROUP_TYPE
5122: AND AG.DESCRIPTIVE_FLEX_CONTEXT_CODE = EAV.ATTR_GROUP_NAME