VIEW: APPS.OKL_BPD_DISB_LOV_UV

Source

View Text - Preformatted

SELECT khr.id CONTRACT_ID, khr.contract_number contract_number, khr.currency_code currency_code, v.id1 vendor_id, v.name vendor_name , v_site.vendor_site_id vendor_site_id, v_site.vendor_site_code vendor_site_code, v_site.pay_group_lookup_code pay_group_lookup_code, v_site.payment_method_lookup_code payment_method_lookup_code, v_site.terms_id terms_id, v_terms.terms terms FROM PO_VENDOR_SITES_ALL V_SITE,OKX_VENDORS_V V,OKC_K_PARTY_ROLES_V PARTY_ROLE,OKC_K_HEADERS_B KHR,OKL_BPD_PAY_TERMS_V V_TERMS WHERE khr.id = party_role.chr_id AND party_role.rle_code = 'OKL_VENDOR' AND v.id1 = party_role.OBJECT1_ID1 AND v_site.vendor_id = v.id1 AND v_site.pay_site_flag = 'Y' AND v_site.terms_id = v_terms.term_id

View Text - HTML Formatted

SELECT KHR.ID CONTRACT_ID
, KHR.CONTRACT_NUMBER CONTRACT_NUMBER
, KHR.CURRENCY_CODE CURRENCY_CODE
, V.ID1 VENDOR_ID
, V.NAME VENDOR_NAME
, V_SITE.VENDOR_SITE_ID VENDOR_SITE_ID
, V_SITE.VENDOR_SITE_CODE VENDOR_SITE_CODE
, V_SITE.PAY_GROUP_LOOKUP_CODE PAY_GROUP_LOOKUP_CODE
, V_SITE.PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE
, V_SITE.TERMS_ID TERMS_ID
, V_TERMS.TERMS TERMS
FROM PO_VENDOR_SITES_ALL V_SITE
, OKX_VENDORS_V V
, OKC_K_PARTY_ROLES_V PARTY_ROLE
, OKC_K_HEADERS_B KHR
, OKL_BPD_PAY_TERMS_V V_TERMS
WHERE KHR.ID = PARTY_ROLE.CHR_ID
AND PARTY_ROLE.RLE_CODE = 'OKL_VENDOR'
AND V.ID1 = PARTY_ROLE.OBJECT1_ID1
AND V_SITE.VENDOR_ID = V.ID1
AND V_SITE.PAY_SITE_FLAG = 'Y'
AND V_SITE.TERMS_ID = V_TERMS.TERM_ID