Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_KHR_TNC_BILL_SETUP_UV |
SELECT CHR.ID
, CHR.BILL_TO_SITE_USE_ID
, CSU.LOCATION BILL_TO_SITE_NAME
, TO_CHAR(NULL) RGP_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) LAINVD_RULE_INFORMATION1
, TO_CHAR(NULL) LAINVD_INVOICE_FORMAT_MEANING
, TO_CHAR(NULL) LAINVD_RULE_INFORMATION3
, TO_CHAR(NULL) LAINVD_RULE_INFORMATION4
, TO_CHAR(NULL) RUL_LAINVD_OBJECT1_ID1
, TO_CHAR(NULL) RUL_LAINVD_OBJECT1_ID2
, TO_CHAR(NULL) RUL_LAINVD_NAME
, TO_CHAR(NULL) LAINPR_RULE_INFORMATION1
, TO_CHAR(NULL) LAINPR_RULE_INFORMATION2
, CHR.CUST_ACCT_ID
FROM OKC_K_HEADERS_B CHR
, HZ_CUST_SITE_USES_ALL CSU
WHERE CSU.SITE_USE_ID(+) = CHR.BILL_TO_SITE_USE_ID