VIEW: APPS.OKL_K_LINE_VENDORS_UV

Source

View Text - Preformatted

SELECT lty_code, party.id id, name, description, rle_code, jtot_object1_code, object1_id1, object1_id2, line.dnz_chr_id dnz_chr_id, line.chr_id chr_id, line.id cle_id, cpl_id FROM OKC_K_PARTY_ROLES_B PARTY,OKX_VENDORS_V VEN,OKC_K_LINES_B LINE,OKC_LINE_STYLES_B STY WHERE line.lse_id = sty.id and line.id = party.cle_id and party.object1_id1 = ven.id1 and party.object1_id2 = ven.id2 and party.dnz_chr_id = line.dnz_chr_id

View Text - HTML Formatted

SELECT LTY_CODE
, PARTY.ID ID
, NAME
, DESCRIPTION
, RLE_CODE
, JTOT_OBJECT1_CODE
, OBJECT1_ID1
, OBJECT1_ID2
, LINE.DNZ_CHR_ID DNZ_CHR_ID
, LINE.CHR_ID CHR_ID
, LINE.ID CLE_ID
, CPL_ID
FROM OKC_K_PARTY_ROLES_B PARTY
, OKX_VENDORS_V VEN
, OKC_K_LINES_B LINE
, OKC_LINE_STYLES_B STY
WHERE LINE.LSE_ID = STY.ID
AND LINE.ID = PARTY.CLE_ID
AND PARTY.OBJECT1_ID1 = VEN.ID1
AND PARTY.OBJECT1_ID2 = VEN.ID2
AND PARTY.DNZ_CHR_ID = LINE.DNZ_CHR_ID