VIEW: APPS.OKL_OR_ASSET_BILLING_SETUP_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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