Product: | XNC - Sales for Communications (Obsolete) |
---|---|
Description: | XNC_BILLING_PREFERENCES_V retrieves billing preferences for a customer account. |
Implementation/DBA Data: | Not implemented in this database |
SELECT BILL.ROWID
, BILL.CUST_ACCOUNT_ID
, BILLING_PREFERENCES_ID
, BILL.SITE_USE_ID
, BILL_LANGUAGE
, LANG.NLS_LANGUAGE 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
FROM JTF_BILLING_PREFERENCES_V BILL
, JTF_CUST_ACCOUNTS_V 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(+)