View: OKL_LA_VENDOR_BILLING_UV

Product:	OKL - Lease and Finance Management
Description:	OKL Vendor billing view
Implementation/DBA Data:	APPS.OKL_LA_VENDOR_BILLING_UV

View Text

SELECT CHRB.ID CHR_ID
, RGPB.ID RGP_ID
, CPLB.ID CPL_ID
, RULB.ID CUST_RULE_ID
, RULB.OBJECT1_ID1 CUST_ID
, HZP.PARTY_NAME CUST_NAME
, CPLB.CUST_ACCT_ID CUST_ACCT_ID
, HZC.ACCOUNT_NUMBER CUST_ACCOUNT_NUMBER
, HZC.ACCOUNT_NAME CUST_ACCOUNT_NAME
, CPLB.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, HZCSU.LOCATION BILL_TO_SITE_USE_NAME
FROM OKC_K_HEADERS_B CHRB
, OKC_K_PARTY_ROLES_B CPLB
, HZ_CUST_ACCOUNTS HZC
, HZ_CUST_SITE_USES_ALL HZCSU
, OKC_RG_PARTY_ROLES RGRP
, OKC_RULE_GROUPS_B RGPB
, HZ_PARTIES HZP
, OKC_RULES_B RULB
WHERE CPLB.DNZ_CHR_ID = CHRB.ID
AND CPLB.CHR_ID = CHRB.ID
AND HZC.CUST_ACCOUNT_ID(+) = CPLB.CUST_ACCT_ID
AND HZCSU.SITE_USE_ID(+) = CPLB.BILL_TO_SITE_USE_ID
AND RGPB.RGD_CODE = 'LAVENB'
AND RGPB.DNZ_CHR_ID = CHRB.ID
AND RGPB.CHR_ID = CHRB.ID
AND RGRP.RGP_ID = RGPB.ID
AND RGRP.DNZ_CHR_ID = CHRB.ID
AND RGRP.CPL_ID = CPLB.ID
AND RULB.RULE_INFORMATION_CATEGORY = 'LAVENC'
AND RULB.RGP_ID = RGPB.ID
AND RULB.DNZ_CHR_ID = CHRB.ID
AND HZP.PARTY_ID(+) = RULB.OBJECT1_ID1

Columns