VIEW: APPS.AST_BILLING_PREFERENCES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)