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_ITEM_WS_PVT dependencies on EGO_ATTRS_V

Line 149: ego_attrs_v attr, EGO_STYLE_VARIANT_ATTR_VS var,

145: ent.PK1_VALUE AS "INVENTORY_ITEM_ID",
146: ent.PK2_VALUE AS "ORGANIZATION_ID",
147: ent.PK3_VALUE, FLAT.SEQUENCE_ID
148: FROM
149: ego_attrs_v attr, EGO_STYLE_VARIANT_ATTR_VS var,
150: ego_attr_groups_v agv, mtl_system_items_b msib,
151: EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat
152: WHERE
153: var.ATTRIBUTE_ID = attr.ATTR_ID

Line 225: ego_attrs_v attr, EGO_STYLE_VARIANT_ATTR_VS var, ego_attr_groups_v agv,

221: var.ATTRIBUTE_ID , attr.ATTR_NAME ,
222: var.VALUE_SET_ID , ent.PK3_VALUE ,
223: FLAT.SEQUENCE_ID
224: FROM
225: ego_attrs_v attr, EGO_STYLE_VARIANT_ATTR_VS var, ego_attr_groups_v agv,
226: EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat
227: WHERE
228: var.ATTRIBUTE_ID = attr.ATTR_ID
229: AND agv.ATTR_GROUP_NAME = attr.ATTR_GROUP_NAME

Line 623: ego_attrs_v eav, EGO_VALUE_SET_VALUES_V evsv

619: null as TRANSLATED_CHAR_VALUE,
620: REVISION_ID
621: FROM ego_all_attr_base_v)
622: ) list , EGO_PUB_WS_FLAT_RECS flat ,
623: ego_attrs_v eav, EGO_VALUE_SET_VALUES_V evsv
624: WHERE
625: list.ATTRIBUTEGROUP_ID = FLAT.REF1_VALUE
626: AND list.EXTENSION_ID = FLAT.REF2_VALUE
627: AND list.INVENTORY_ITEM_ID = FLAT.PK1_VALUE

Line 769: EGO_ATTRS_V AGC, EGO_ATTR_GROUPS_V AG

765: ), 'MM/DD/YYYY HH24:MI:SS'
766: ) AS ATTRIBUTE_DATETIME_VALUE
767:
768: FROM EGO_MTL_SY_ITEMS_EXT_B UDA , EGO_PUB_WS_FLAT_RECS flat ,
769: EGO_ATTRS_V AGC, EGO_ATTR_GROUPS_V AG
770:
771: WHERE UDA.ATTR_GROUP_ID = AG.ATTR_GROUP_ID
772: AND AGC.APPLICATION_ID = AG.APPLICATION_ID
773: AND AGC.ATTR_GROUP_TYPE = AG.ATTR_GROUP_TYPE

Line 873: ego_attrs_v eav

869: null as TRANSLATED_CHAR_VALUE,
870: REVISION_ID
871: FROM ego_all_attr_base_v)
872: ) list , EGO_PUB_WS_FLAT_RECS flat ,
873: ego_attrs_v eav
874: WHERE
875: list.ATTRIBUTEGROUP_ID = FLAT.REF1_VALUE
876: AND list.EXTENSION_ID = FLAT.REF2_VALUE
877: AND list.INVENTORY_ITEM_ID = FLAT.PK1_VALUE

Line 996: EGO_ATTRS_V AGC, EGO_ATTR_GROUPS_V AG

992: ), 'MM/DD/YYYY HH24:MI:SS'
993: ) AS ATTRIBUTE_DATETIME_VALUE
994:
995: FROM EGO_MTL_SY_ITEMS_EXT_B UDA , EGO_PUB_WS_FLAT_RECS flat ,
996: EGO_ATTRS_V AGC, EGO_ATTR_GROUPS_V AG
997:
998: WHERE UDA.ATTR_GROUP_ID = AG.ATTR_GROUP_ID
999: AND AGC.APPLICATION_ID = AG.APPLICATION_ID
1000: AND AGC.ATTR_GROUP_TYPE = AG.ATTR_GROUP_TYPE

Line 1071: , ego_attrs_v eav -- Bug 9542020

1067: REVISION_ID
1068: FROM ego_all_attr_lang_v
1069: where language = userenv('LANG'))
1070: ) list , EGO_PUB_WS_FLAT_RECS flat
1071: , ego_attrs_v eav -- Bug 9542020
1072: WHERE
1073: list.ATTRIBUTEGROUP_ID = FLAT.REF1_VALUE
1074: AND list.EXTENSION_ID = FLAT.REF2_VALUE
1075: AND list.INVENTORY_ITEM_ID = FLAT.PK1_VALUE

Line 1155: EGO_ATTRS_V AGC, EGO_ATTR_GROUPS_V AG

1151: 'TL_EXT_ATTR35', UDA.TL_EXT_ATTR35, 'TL_EXT_ATTR36', UDA.TL_EXT_ATTR36, 'TL_EXT_ATTR37', UDA.TL_EXT_ATTR37, 'TL_EXT_ATTR38', UDA.TL_EXT_ATTR38,
1152: 'TL_EXT_ATTR39', UDA.TL_EXT_ATTR39, 'TL_EXT_ATTR40', UDA.TL_EXT_ATTR40 )
1153: ) AS ATTRIBUTE_TRANSLATABLE_VALUE
1154: FROM EGO_MTL_SY_ITEMS_EXT_TL UDA , EGO_PUB_WS_FLAT_RECS flat ,
1155: EGO_ATTRS_V AGC, EGO_ATTR_GROUPS_V AG
1156:
1157: WHERE UDA.ATTR_GROUP_ID = AG.ATTR_GROUP_ID
1158: AND AGC.APPLICATION_ID = AG.APPLICATION_ID
1159: AND AGC.ATTR_GROUP_TYPE = AG.ATTR_GROUP_TYPE

Line 1289: EGO_ATTRS_V AGC, EGO_ATTR_GROUPS_V AG , EGO_PUB_WS_CONFIG CONFIG

1285: 'TL_EXT_ATTR39', UDA.TL_EXT_ATTR39, 'TL_EXT_ATTR40', UDA.TL_EXT_ATTR40 )
1286: ) AS ATTRIBUTE_TRANSLATABLE_VALUE
1287:
1288: FROM EGO_MTL_SY_ITEMS_EXT_TL UDA , EGO_PUB_WS_FLAT_RECS flat ,
1289: EGO_ATTRS_V AGC, EGO_ATTR_GROUPS_V AG , EGO_PUB_WS_CONFIG CONFIG
1290:
1291: WHERE UDA.ATTR_GROUP_ID = AG.ATTR_GROUP_ID
1292: AND AGC.APPLICATION_ID = AG.APPLICATION_ID
1293: AND AGC.ATTR_GROUP_TYPE = AG.ATTR_GROUP_TYPE

Line 1461: ego_attrs_v attrs ,

1457: attrs.attr_id ,
1458: attrs.attr_name ,
1459: hier.lev lev
1460: FROM ego_obj_AG_assocs_b assocs ,
1461: ego_attrs_v attrs ,
1462: ego_attr_groups_v ag ,
1463: EGO_TRANS_ATTR_VERS_B versions,
1464: mtl_item_catalog_groups_kfv icv ,
1465: (

Line 3351: FROM ego_attrs_v

3347: BEGIN
3348: /* Need to validate for valid input values */
3349: SELECT ATTR_ID
3350: INTO l_ta_attr_id_tab(i)
3351: FROM ego_attrs_v
3352: WHERE ATTR_NAME = l_ta_attr_name_tab(i)
3353: AND ATTR_GROUP_TYPE = 'EGO_ITEM_TRANS_ATTR_GROUP';
3354:
3355: EXCEPTION

Line 3381: FROM ego_attrs_v

3377: l_ta_attr_name_tab(i) := NULL;
3378:
3379: WHEN Too_Many_Rows THEN
3380: FOR j IN ( SELECT ATTR_ID
3381: FROM ego_attrs_v
3382: WHERE ATTR_NAME = l_ta_attr_name_tab(i)
3383: AND ATTR_GROUP_TYPE = 'EGO_ITEM_TRANS_ATTR_GROUP')
3384: LOOP
3385: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 3398: FROM ego_attrs_v

3394: BEGIN
3395: /* Need to validate for valid input values */
3396: SELECT ATTR_ID
3397: INTO l_ta_attr_id_tab(i)
3398: FROM ego_attrs_v
3399: WHERE ATTR_ID = l_ta_attr_id_tab(i)
3400: AND ATTR_GROUP_TYPE = 'EGO_ITEM_TRANS_ATTR_GROUP';
3401:
3402: EXCEPTION