DBA Data[Home] [Help]

APPS.MTH_PROCESS_UDA_PKG dependencies on MTH_USER_ENTITIES_EXT_B

Line 568: FROM MTH_USER_ENTITIES_EXT_B e,

564: OR (P_ENTITY='PRODUCTION_SEGMENTS' AND stg_egv.ATTR_NAME='SEGMENT' AND stg_egv.ATTR_VALUE NOT IN (SELECT SEGMENT_PK_KEY FROM MTH_PRODUCTION_SEGMENTS_EXT_B))
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

Line 641: FROM MTH_USER_ENTITIES_EXT_B e,

637: OR (P_ENTITY='PRODUCTION_SEGMENTS' AND stg_egv.ATTR_NAME='SEGMENT' AND stg_egv.ATTR_VALUE NOT IN (SELECT SEGMENT_PK_KEY FROM MTH_PRODUCTION_SEGMENTS_EXT_B))
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