DBA Data[Home] [Help]

APPS.MTH_PROCESS_UDA_PKG dependencies on MTH_ITEMS_EXT_B

Line 561: OR (P_ENTITY='ITEMS' AND stg_egv.ATTR_NAME='ITEM' AND stg_egv.ATTR_VALUE NOT IN (SELECT ITEM_PK_KEY FROM MTH_ITEMS_EXT_B))

557: )
558: OR (stg_egv.ATTR_GROUP_ID IS NULL)
559: OR (eav.REQUIRED_FLAG ='Y' AND stg_egv.ATTR_VALUE IS NULL)
560: OR (P_ENTITY='EQUIPMENTS' AND stg_egv.ATTR_NAME='EQUIPMENT' AND stg_egv.ATTR_VALUE NOT IN (SELECT EQUIPMENT_PK_KEY FROM MTH_EQUIPMENTS_D))
561: OR (P_ENTITY='ITEMS' AND stg_egv.ATTR_NAME='ITEM' AND stg_egv.ATTR_VALUE NOT IN (SELECT ITEM_PK_KEY FROM MTH_ITEMS_EXT_B))
562: OR (P_ENTITY='OTHERS' AND stg_egv.ATTR_NAME='OTHER' AND stg_egv.ATTR_VALUE NOT IN (SELECT OTHER_PK_KEY FROM MTH_OTHERS_EXT_B))
563: OR (P_ENTITY='PRODUCTION_SCHEDULES' AND stg_egv.ATTR_NAME='WORKORDER' AND stg_egv.ATTR_VALUE NOT IN (SELECT WORKORDER_PK_KEY FROM MTH_PRODUCTION_SCHEDULES_EXT_B))
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

Line 634: OR (P_ENTITY='ITEMS' AND stg_egv.ATTR_NAME='ITEM' AND stg_egv.ATTR_VALUE NOT IN (SELECT ITEM_PK_KEY FROM MTH_ITEMS_EXT_B))

630: )
631: OR (stg_egv.ATTR_GROUP_ID IS NULL)
632: OR (eav.REQUIRED_FLAG ='Y' AND stg_egv.ATTR_VALUE IS NULL)
633: OR (P_ENTITY='EQUIPMENTS' AND stg_egv.ATTR_NAME='EQUIPMENT' AND stg_egv.ATTR_VALUE NOT IN (SELECT EQUIPMENT_PK_KEY FROM MTH_EQUIPMENTS_D))
634: OR (P_ENTITY='ITEMS' AND stg_egv.ATTR_NAME='ITEM' AND stg_egv.ATTR_VALUE NOT IN (SELECT ITEM_PK_KEY FROM MTH_ITEMS_EXT_B))
635: OR (P_ENTITY='OTHERS' AND stg_egv.ATTR_NAME='OTHER' AND stg_egv.ATTR_VALUE NOT IN (SELECT OTHER_PK_KEY FROM MTH_OTHERS_EXT_B))
636: OR (P_ENTITY='PRODUCTION_SCHEDULES' AND stg_egv.ATTR_NAME='WORKORDER' AND stg_egv.ATTR_VALUE NOT IN (SELECT WORKORDER_PK_KEY FROM MTH_PRODUCTION_SCHEDULES_EXT_B))
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