DBA Data[Home] [Help]

APPS.EGO_ITEM_WS_PVT dependencies on EGO_ATTR_GROUPS_V

Line 63: v_attribute_group_name EGO_ATTR_GROUPS_V.ATTR_GROUP_NAME%TYPE;

59: v_query_string VARCHAR2(32767);
60: v_query_string_Inherit_b VARCHAR2(32767); -- Bug 11738301
61:
62: v_attribute_group_id EGO_MTL_SY_ITEMS_EXT_B.ATTR_GROUP_ID%TYPE;
63: v_attribute_group_name EGO_ATTR_GROUPS_V.ATTR_GROUP_NAME%TYPE;
64: v_organization_id EGO_MTL_SY_ITEMS_EXT_B.organization_id%TYPE;
65: v_inventory_item_id EGO_MTL_SY_ITEMS_EXT_B.inventory_item_id%TYPE;
66: v_revision_id EGO_MTL_SY_ITEMS_EXT_B.revision_id%TYPE;
67: v_application_id EGO_ATTR_GROUPS_V.application_id%TYPE;

Line 67: v_application_id EGO_ATTR_GROUPS_V.application_id%TYPE;

63: v_attribute_group_name EGO_ATTR_GROUPS_V.ATTR_GROUP_NAME%TYPE;
64: v_organization_id EGO_MTL_SY_ITEMS_EXT_B.organization_id%TYPE;
65: v_inventory_item_id EGO_MTL_SY_ITEMS_EXT_B.inventory_item_id%TYPE;
66: v_revision_id EGO_MTL_SY_ITEMS_EXT_B.revision_id%TYPE;
67: v_application_id EGO_ATTR_GROUPS_V.application_id%TYPE;
68: v_extension_id EGO_MTL_SY_ITEMS_EXT_B.extension_id%TYPE;
69: v_data_level_id EGO_MTL_SY_ITEMS_EXT_B.data_level_id%TYPE;
70: v_pk1_value EGO_MTL_SY_ITEMS_EXT_B.pk1_value%TYPE;
71: v_pk2_value EGO_MTL_SY_ITEMS_EXT_B.pk2_value%TYPE;

Line 150: ego_attr_groups_v agv, mtl_system_items_b msib,

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
154: AND agv.ATTR_GROUP_NAME = attr.ATTR_GROUP_NAME

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 261: ' FROM EGO_MTL_SY_ITEMS_EXT_B egob, EGO_ATTR_GROUPS_V AG, '||

257: ' edlv.USER_DATA_LEVEL_NAME AS "DATA_LEVEL_NAME" , '||
258: ' flat.SEQUENCE_ID , '||
259: ' ent.PK3_VALUE AS "PK3_VALUE" , '||
260: ' flat.PK2_VALUE AS "ORG_ID" '||
261: ' FROM EGO_MTL_SY_ITEMS_EXT_B egob, EGO_ATTR_GROUPS_V AG, '||
262: ' EGO_DATA_LEVEL_VL edlv , EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat '||
263: ' WHERE egob.DATA_LEVEL_ID = edlv.DATA_LEVEL_ID '||
264: ' AND AG.APPLICATION_ID = edlv.APPLICATION_ID '||
265: ' AND egob.ATTR_GROUP_ID = AG.ATTR_GROUP_ID '||

Line 288: ' FROM EGO_MTL_SY_ITEMS_EXT_B egob, EGO_ATTR_GROUPS_V AG, ego_attr_group_dl AGDL, mtl_system_items_b msib, '||

284: ' edlv.USER_DATA_LEVEL_NAME AS "DATA_LEVEL_NAME" , '||
285: ' flat.SEQUENCE_ID , '||
286: ' ent.PK3_VALUE AS "PK3_VALUE" , '||
287: ' flat.PK2_VALUE AS "ORG_ID" '||
288: ' FROM EGO_MTL_SY_ITEMS_EXT_B egob, EGO_ATTR_GROUPS_V AG, ego_attr_group_dl AGDL, mtl_system_items_b msib, '||
289: ' EGO_DATA_LEVEL_VL edlv , EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat '||
290: ' WHERE egob.DATA_LEVEL_ID = edlv.DATA_LEVEL_ID '||
291: ' AND egob.DATA_LEVEL_ID = AGDL.DATA_LEVEL_ID '||
292: ' AND AG.APPLICATION_ID = edlv.APPLICATION_ID '||

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 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 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 1462: ego_attr_groups_v ag ,

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: (
1466: SELECT item_catalog_group_id,

Line 3210: FROM ego_attr_groups_v

3206: BEGIN
3207: /* Need to validate for valid input values */
3208: SELECT ATTR_GROUP_NAME
3209: INTO l_uda_attr_name_tab(i) -- v_attr_group_name
3210: FROM ego_attr_groups_v
3211: WHERE ATTR_GROUP_NAME = l_uda_attr_name_tab(i)
3212: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
3213:
3214: EXCEPTION

Line 3241: FROM ego_attr_groups_v

3237: BEGIN
3238: /* Need to validate for valid input values */
3239: SELECT ATTR_GROUP_NAME
3240: INTO l_uda_attr_name_tab(i) -- v_attr_group_name
3241: FROM ego_attr_groups_v
3242: WHERE ATTR_GROUP_ID = l_uda_attr_id_tab(i)
3243: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
3244:
3245: EXCEPTION