FOD_SALES_SETUP_STATUS_VL

Details

• Schema: FUSION

• Object owner: FOD

• Object type: VIEW

Columns

Name
RULE_ID RULE_DESC RULE_NAME RECOMMENDATION STATUS

Query

SQL_Statement

SELECT txn.RULE_ID, tl.RULE_DESC, tl.RULE_NAME, fnd.MESSAGE_TEXT||fnd.MESSAGE_USER_DETAILS RECOMMENDATION, nvl(lookup.meaning,txn.STATUS) STATUS FROM fod_sales_setup_status txn JOIN fod_sales_setup_validn_b base on base.RULE_CODE = txn.RULE_CODE JOIN fod_sales_setup_validn_tl tl on base.RULE_CODE = tl.RULE_CODE LEFT JOIN FND_MESSAGES_TL fnd ON fnd.message_name =txn.REC_CODE AND fnd.LANGUAGE = USERENV ('LANG') LEFT JOIN fnd_lookup_values lookup on txn.STATUS = lookup.LOOKUP_CODE and lookup.LOOKUP_TYPE = 'ORA_FOD_SETUP_VALIDN_STATUS' and lookup.LANGUAGE = USERENV ('LANG') WHERE tl.LANGUAGE = USERENV ('LANG') ORDER BY base.SEQUENCE