VIEW: APPS.BIL_TX_FCST_TYP_V

Source

View Text - Preformatted

SELECT to_number(fnd_profile.value('ASN_FRCST_CREDIT_TYPE_ID')) id , 'Revenue' value from dual union select sales_credit_type_id id , name value from oe_sales_credit_types where enabled_flag = 'Y' and quota_flag = 'N' order by id

View Text - HTML Formatted

SELECT TO_NUMBER(FND_PROFILE.VALUE('ASN_FRCST_CREDIT_TYPE_ID')) ID
, 'REVENUE' VALUE
FROM DUAL UNION SELECT SALES_CREDIT_TYPE_ID ID
, NAME VALUE
FROM OE_SALES_CREDIT_TYPES
WHERE ENABLED_FLAG = 'Y'
AND QUOTA_FLAG = 'N' ORDER BY ID