View: OKL_OR_ASSET_BILLING_SETUP_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_OR_ASSET_BILLING_SETUP_UV

View Text

SELECT CLET.NAME
, CLET.ITEM_DESCRIPTION
, CLEB_FIN.ID
, CLEB_FIN.DNZ_CHR_ID
, CLEB_FIN.BILL_TO_SITE_USE_ID
, CSU.LOCATION BILL_TO_SITE_NAME
, CSU.CUST_ACCT_SITE_ID
, TO_CHAR(NULL) RGP_LABILL_LAPMTH_ID
, TO_CHAR(NULL) RGP_LABILL_LABACC_ID
, TO_CHAR(NULL) RGP_LABILL_LAINVD_ID
, TO_CHAR(NULL) RGP_LABILL_LAINPR_ID
, TO_CHAR(NULL) RUL_LAPMTH_ID
, TO_CHAR(NULL) RUL_LABACC_ID
, TO_CHAR(NULL) RUL_LAINVD_ID
, TO_CHAR(NULL) RUL_LAINPR_ID
, TO_CHAR(NULL) RUL_LAPMTH_OBJECT1_ID1
, TO_CHAR(NULL) RUL_LAPMTH_OBJECT1_ID2
, TO_CHAR(NULL) RUL_LAPMTH_NAME
, TO_CHAR(NULL) RUL_LABACC_OBJECT1_ID1
, TO_CHAR(NULL) RUL_LABACC_OBJECT1_ID2
, TO_CHAR(NULL) RUL_LABACC_NAME
, TO_CHAR(NULL) RUL_LABACC_BANK_NAME
, TO_CHAR(NULL) RGP_ID
FROM HZ_CUST_SITE_USES_ALL CSU
, OKC_K_LINES_TL CLET
, OKC_K_LINES_B CLEB_FIN
WHERE CLEB_FIN.ID = CLET.ID
AND CSU.SITE_USE_ID(+) = CLEB_FIN.BILL_TO_SITE_USE_ID

Columns