DBA Data[Home] [Help]

APPS.EGO_TA_BULKLOAD_PVT dependencies on EGO_ATTRS_V

Line 846: FROM ego_attrs_v EAV

842: update as here we are sure we got the attr_id so populating attr_name
843: if not given*/
844: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
845: SET attr_name= (SELECT attr_name
846: FROM ego_attrs_v EAV
847: WHERE EAV.attr_id= ETAVT.attr_id
848: )
849: WHERE ETAVT.attr_id IS NOT NULL
850: AND ETAVT.attr_display_name IS NOT NULL

Line 2324: FROM ego_attrs_v EAV

2320: /* assigning defaults required for update*/
2321: IF p_ta_intf_tbl(i).attr_display_name IS NOT NULL THEN
2322: BEGIN
2323: SELECT attr_name INTO p_ta_intf_tbl(i).attr_name
2324: FROM ego_attrs_v EAV
2325: WHERE EAV.attr_id= p_ta_intf_tbl(i).attr_id;
2326: END ;
2327: END IF;
2328:

Line 3102: ego_attrs_v attrs ,

3098: attrs.attr_name ,
3099: attrs.attr_id ,
3100: hier.lev
3101: FROM ego_obj_AG_assocs_b assocs ,
3102: ego_attrs_v attrs ,
3103: ego_attr_groups_v ag ,
3104: EGO_TRANS_ATTR_VERS_B versions ,
3105: mtl_item_catalog_groups_kfv icv ,
3106: (SELECT item_catalog_group_id ,

Line 3171: EGO_ATTRS_V ATTRS ,

3167: versions.metadata_level ,
3168: attrs.attr_name ,
3169: Hier.lev
3170: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
3171: EGO_ATTRS_V ATTRS ,
3172: (SELECT ITEM_CATALOG_GROUP_ID ,
3173: LEVEL LEV
3174: FROM MTL_ITEM_CATALOG_GROUPS_B START
3175: WITH ITEM_CATALOG_GROUP_ID = p_item_cat_group_id CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID