[Home] [Help]
View: OKL_BPD_CNTR_LVLNG_LOV_UV
View Text
SELECT DISTINCT CUST.ID1 CUST_ACCT_ID1
, BTO.ID1 BTO_ID1
, PMTH.ID1 PMTH_ID1
, CUST.PARTY_ID PARTY_ID
, CUST.NAME CUSTOMER_NAME
, BTO.LOCATION_ID LOCATION_ID
, BTO.NAME BILL_TO_SITE_NAME
, PMTH.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, PMTH.PAYMENT_TYPE_CODE PAYMENT_TERM
, PMTH.NAME PAYMENT_METHOD
FROM OKC_K_HEADERS_B KHR
, OKC_RULE_GROUPS_B RGP
, OKC_RULES_B RUL3
, OKX_CUSTOMER_ACCOUNTS_V CUST
, OKX_CUST_SITE_USES_V BTO
, OKX_RECEIPT_METHODS_V PMTH
WHERE KHR.CUST_ACCT_ID = CUST.ID1
AND BTO.ID1 = KHR.BILL_TO_SITE_USE_ID
AND BTO.CUST_ACCOUNT_ID = KHR.CUST_ACCT_ID
AND RUL3.RULE_INFORMATION_CATEGORY = 'LAPMTH'
AND RUL3.DNZ_CHR_ID = KHR.ID
AND PMTH.ID1 = RUL3.OBJECT1_ID1
AND PMTH.ID2 = RUL3.OBJECT1_ID2
AND RUL3.RGP_ID = RGP.ID
AND RGP.CHR_ID = KHR.ID
AND RGP.RGD_CODE = 'LABILL'
Columns
Name |
CUST_ACCT_ID1 |
BTO_ID1 |
PMTH_ID1 |
PARTY_ID |
CUSTOMER_NAME |
LOCATION_ID |
BILL_TO_SITE_NAME |
RECEIPT_METHOD_ID |
PAYMENT_TERM |
PAYMENT_METHOD |