View: AST_BILLING_PREFERENCES_V

Product:	AST - TeleSales
Description:	AST_BILLING_PREFERENCES_V retrieves billing preferences for a customer account.
Implementation/DBA Data:	APPS.AST_BILLING_PREFERENCES_V

View Text

SELECT BILL.ROWID
, BILL.CUST_ACCOUNT_ID
, BILLING_PREFERENCES_ID
, BILL.SITE_USE_ID
, BILL.BILL_LANGUAGE
, LANG.DESCRIPTION
, LANG.NLS_LANGUAGE
, BILL_ROUND_NUMBER
, BILL_TYPE
, MEDIA_FORMAT
, MEDIA_TYPE
, NUMBER_OF_COPIES
, BILL.CURRENCY_CODE
, CURRENCY.NAME CURRENCY_NAME
, HELD_BILL_EXPIRATION_DATE
, HOLD_BILL_FLAG
, PAYMENT_TERM_ID
, BILL.LAST_UPDATE_DATE
, BILL.LAST_UPDATED_BY
, BILL.CREATION_DATE
, BILL.CREATED_BY
, BILL.LAST_UPDATE_LOGIN
FROM HZ_BILLING_PREFERENCES BILL
, HZ_CUST_ACCOUNTS CUST
, FND_LANGUAGES_VL LANG
, FND_CURRENCIES_VL CURRENCY
WHERE BILL.CUST_ACCOUNT_ID = CUST.CUST_ACCOUNT_ID
AND BILL.BILL_LANGUAGE = LANG.LANGUAGE_CODE(+)
AND BILL.CURRENCY_CODE = CURRENCY.CURRENCY_CODE(+)

Columns