VIEW: APPS.OKL_BPD_CNTR_LVLNG_LOV_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'