VIEW: APPS.BIL_TX_FW_ST_V

Source

View Text - Preformatted

SELECT TO_CHAR(SALES_CREDIT_TYPE_ID) ID, NAME VALUE FROM OE_SALES_CREDIT_TYPES WHERE ENABLED_FLAG = 'Y' AND QUOTA_FLAG = 'N' UNION ALL select lookup_CODE ID , meaning VALUE from fnd_lookup_values where lookup_type = 'BIL_TX_SALES_TEAM' AND LANGUAGE = USERENV('LANG') UNION ALL SELECT fnd_profile.value('ASN_FRCST_CREDIT_TYPE_ID') ID , FND_MESSAGE.GET_STRING('BIL','BIL_TX_REVENUE') VALUE FROM DUAL

View Text - HTML Formatted

SELECT TO_CHAR(SALES_CREDIT_TYPE_ID) ID
, NAME VALUE
FROM OE_SALES_CREDIT_TYPES
WHERE ENABLED_FLAG = 'Y'
AND QUOTA_FLAG = 'N' UNION ALL SELECT LOOKUP_CODE ID
, MEANING VALUE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'BIL_TX_SALES_TEAM'
AND LANGUAGE = USERENV('LANG') UNION ALL SELECT FND_PROFILE.VALUE('ASN_FRCST_CREDIT_TYPE_ID') ID
, FND_MESSAGE.GET_STRING('BIL'
, 'BIL_TX_REVENUE') VALUE
FROM DUAL