DBA Data[Home] [Help]

APPS.EGO_ITEM_WS_PVT dependencies on EGO_MTL_SY_ITEMS_EXT_B

Line 62: v_attribute_group_id EGO_MTL_SY_ITEMS_EXT_B.ATTR_GROUP_ID%TYPE;

58: v_query_string_b VARCHAR2(32767);
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;

Line 64: v_organization_id EGO_MTL_SY_ITEMS_EXT_B.organization_id%TYPE;

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;
68: v_extension_id EGO_MTL_SY_ITEMS_EXT_B.extension_id%TYPE;

Line 65: v_inventory_item_id EGO_MTL_SY_ITEMS_EXT_B.inventory_item_id%TYPE;

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;
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;

Line 66: v_revision_id EGO_MTL_SY_ITEMS_EXT_B.revision_id%TYPE;

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;
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;

Line 68: v_extension_id EGO_MTL_SY_ITEMS_EXT_B.extension_id%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;
72: v_data_level_name EGO_DATA_LEVEL_VL.user_data_level_name%TYPE;

Line 69: v_data_level_id EGO_MTL_SY_ITEMS_EXT_B.data_level_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;
72: v_data_level_name EGO_DATA_LEVEL_VL.user_data_level_name%TYPE;
73: v_sequence_id EGO_PUB_WS_FLAT_RECS.sequence_id%TYPE;

Line 70: v_pk1_value EGO_MTL_SY_ITEMS_EXT_B.pk1_value%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;
72: v_data_level_name EGO_DATA_LEVEL_VL.user_data_level_name%TYPE;
73: v_sequence_id EGO_PUB_WS_FLAT_RECS.sequence_id%TYPE;
74: v_pk3_value EGO_ODI_WS_ENTITIES.pk3_value%TYPE;

Line 71: v_pk2_value EGO_MTL_SY_ITEMS_EXT_B.pk2_value%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;
72: v_data_level_name EGO_DATA_LEVEL_VL.user_data_level_name%TYPE;
73: v_sequence_id EGO_PUB_WS_FLAT_RECS.sequence_id%TYPE;
74: v_pk3_value EGO_ODI_WS_ENTITIES.pk3_value%TYPE;
75: v_org_id EGO_PUB_WS_FLAT_RECS.PK2_VALUE%TYPE;

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 768: FROM EGO_MTL_SY_ITEMS_EXT_B UDA , EGO_PUB_WS_FLAT_RECS flat ,

764: 'D_EXT_ATTR6', UDA.D_EXT_ATTR6, 'D_EXT_ATTR7', UDA.D_EXT_ATTR7, 'D_EXT_ATTR8', UDA.D_EXT_ATTR8, 'D_EXT_ATTR9', UDA.D_EXT_ATTR9, 'D_EXT_ATTR10', UDA.D_EXT_ATTR10)
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

Line 995: FROM EGO_MTL_SY_ITEMS_EXT_B UDA , EGO_PUB_WS_FLAT_RECS flat ,

991: 'D_EXT_ATTR6', UDA.D_EXT_ATTR6, 'D_EXT_ATTR7', UDA.D_EXT_ATTR7, 'D_EXT_ATTR8', UDA.D_EXT_ATTR8, 'D_EXT_ATTR9', UDA.D_EXT_ATTR9, 'D_EXT_ATTR10', UDA.D_EXT_ATTR10)
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