APPS.MTH_PROCESS_UDA_PKG dependencies on MTH_EXT_ATTR_I_STG

Line 534: mth_ext_attr_i_stg stg

530: egv.attr_group_name,
531: egv.attr_group_id,
532: egv.attr_group_type
533: FROM ego_attr_groups_v egv,
534: mth_ext_attr_i_stg stg
535: WHERE egv.APPLICATION_ID(+) = 9001
536: AND egv.ATTR_GROUP_TYPE(+) = Decode(P_ENTITY,
537: 'EQUIPMENTS','MTH_EQUIPMENTS_GROUP',
538: 'ITEMS','MTH_ITEMS_GROUP',

Line 569: mth_ext_attr_i_stg s

565: OR (P_ENTITY='USER_ENTITIES' AND stg_egv.ATTR_NAME='USER_ENTITY' AND stg_egv.ATTR_VALUE NOT IN
566: (
567: SELECT e.ENTITY_PK_KEY
568: FROM MTH_USER_ENTITIES_EXT_B e,
569: mth_ext_attr_i_stg s
570: WHERE stg_egv.group_id = s.group_id
571: AND s.ATTR_NAME = 'ENTITY_TYPE'
572: AND s.ATTR_VALUE = e.ENTITY_TYPE
573: )

Line 606: mth_ext_attr_i_stg stg

602: egv.attr_group_name,
603: egv.attr_group_id,
604: egv.attr_group_type
605: FROM ego_attr_groups_v egv,
606: mth_ext_attr_i_stg stg
607: WHERE egv.APPLICATION_ID(+) = 9001
608: AND egv.ATTR_GROUP_TYPE(+) = Decode(P_ENTITY,
609: 'EQUIPMENTS','MTH_EQUIPMENTS_GROUP',
610: 'ITEMS','MTH_ITEMS_GROUP',

Line 642: mth_ext_attr_i_stg s

638: OR (P_ENTITY='USER_ENTITIES' AND stg_egv.ATTR_NAME='USER_ENTITY' AND stg_egv.ATTR_VALUE NOT IN
639: (
640: SELECT e.ENTITY_PK_KEY
641: FROM MTH_USER_ENTITIES_EXT_B e,
642: mth_ext_attr_i_stg s
643: WHERE stg_egv.group_id = s.group_id
644: AND s.ATTR_NAME = 'ENTITY_TYPE'
645: AND s.ATTR_VALUE = e.ENTITY_TYPE
646: )

Line 740: MTH_UTIL_PKG.MTH_TRUNCATE_TABLE('MTH_EXT_ATTR_I_STG');

736: MTH_COMMON_PKG.CALL_NTB_UPLOAD_COMPOSITE_PK(p_entity);
737: ELSE
738: MTH_UDA_PKG.NTB_UPLOAD(p_entity);
739: END IF;
740: MTH_UTIL_PKG.MTH_TRUNCATE_TABLE('MTH_EXT_ATTR_I_STG');
741: MTH_UTIL_PKG.MTH_TRUNCATE_TABLE('MTH_EXT_ATTR_T_STG');
742: p_retcode := 0;
743:
744: mth_util_pkg.log_msg('PROCESS_UDA_STATIC_DATA end', mth_util_pkg.G_DBG_PROC_FUN_END);