Query to Find Defaulting Rules in Order Management for specific Attribute like in below case finding the defaulting rules for REQUEST_DATE (Customer_Request_date or Shcedule_Request_date) field
SELECT dadr.DATABASE_OBJECT_NAME,
dadr.ATTRIBUTE_CODE,
dac.ATTRIBUTE_CODE,
dac.DATABASE_OBJECT_NAME,
aoa.column_name,
aoa.attribute_application_id,
aoa.REQUIRED_FLAG,
DADR.*
FROM oe_def_attr_def_rules dadr,
oe_def_attr_condns dac,
ak_object_attributes aoa
WHERE dadr.ATTR_DEF_CONDITION_ID = dac.ATTR_DEF_CONDITION_ID
AND dac.ENABLED_FLAG = 'Y'
AND dac.ATTRIBUTE_CODE = aoa.ATTRIBUTE_CODE
AND dac.DATABASE_OBJECT_NAME = aoa.DATABASE_OBJECT_NAME
AND UPPER (DADR.SRC_API_FN) LIKE '%REQUEST_DATE%'
SELECT dadr.DATABASE_OBJECT_NAME,
dadr.ATTRIBUTE_CODE,
dac.ATTRIBUTE_CODE,
dac.DATABASE_OBJECT_NAME,
aoa.column_name,
aoa.attribute_application_id,
aoa.REQUIRED_FLAG,
DADR.*
FROM oe_def_attr_def_rules dadr,
oe_def_attr_condns dac,
ak_object_attributes aoa
WHERE dadr.ATTR_DEF_CONDITION_ID = dac.ATTR_DEF_CONDITION_ID
AND dac.ENABLED_FLAG = 'Y'
AND dac.ATTRIBUTE_CODE = aoa.ATTRIBUTE_CODE
AND dac.DATABASE_OBJECT_NAME = aoa.DATABASE_OBJECT_NAME
AND UPPER (DADR.SRC_API_FN) LIKE '%REQUEST_DATE%'
No comments:
Post a Comment