VIEW: APPS.OKL_LA_VENDOR_BILLING_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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