DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on EGO_MTL_SY_ITEMS_EXT_VL

Line 5832: FROM ego_mtl_sy_items_ext_vl

5828:
5829: UPDATE EGO_ITM_USR_ATTR_INTRFC uai2
5830: SET uai2.transaction_type =
5831: DECODE ((SELECT COUNT (1)
5832: FROM ego_mtl_sy_items_ext_vl
5833: WHERE attr_group_id = uai2.attr_group_id
5834: AND ROWNUM < 2
5835: AND inventory_item_id = uai2.inventory_item_id
5836: AND organization_id = uai2.organization_id

Line 5903: l_ext_table_select := ' EGO_MTL_SY_ITEMS_EXT_VL EXTVL1 WHERE EXTVL1.ATTR_GROUP_ID='||l_attr_group_metadata_obj.ATTR_GROUP_ID||' ';

5899: l_attr_metadata_table_sr := l_attr_group_metadata_obj.ATTR_METADATA_TABLE;
5900: l_attr_metadata_table_1 := l_attr_group_metadata_obj.ATTR_METADATA_TABLE;
5901:
5902: IF (l_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y') THEN
5903: l_ext_table_select := ' EGO_MTL_SY_ITEMS_EXT_VL EXTVL1 WHERE EXTVL1.ATTR_GROUP_ID='||l_attr_group_metadata_obj.ATTR_GROUP_ID||' ';
5904:
5905: --LOOP THROUGH ALL THE ATTRS METADATA FOR THIS MR AG
5906: FOR i IN l_attr_metadata_table.FIRST .. l_attr_metadata_table.LAST
5907: LOOP