VIEW: APPS.OKS_LINE_DETAILS_V

Source

View Text - Preformatted

SELECT l.dnz_chr_id contract_id ,l.id LINE_ID ,l.cognomen LINE_REFERENCE ,l.line_number SERVICE_LINE_NUMBER ,x.description SERVICE_NAME ,i.object1_id1 object1_id1 ,i.object1_id2 object1_id2 ,l.start_date SERVICE_START_DATE ,l.end_date SERVICE_END_DATE ,c.name CUSTOMER_ACCOUNT_NAME ,bto.description LINE_BTO_ADDRESS ,sto.description LINE_STO_ADDRESS From Okc_k_lines_v l , Okc_K_Items i, Okx_System_Items_v x, Okx_customer_accounts_v c , OKX_CUST_SITE_USES_V bto, OKX_CUST_SITE_USES_V sto WHERE l.lse_id in (1,12,14,19) And l.cle_id is null And l.chr_id is not null And l.id = i.cle_id And x.id1 = i.object1_id1 And x.id2 = i.object1_id2 And c.id1(+) = l.CUST_ACCT_ID And bto.id1(+) = l.BILL_TO_SITE_USE_ID And sto.id1(+) = l.SHIP_TO_SITE_USE_ID

View Text - HTML Formatted

SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.ID LINE_ID
, L.COGNOMEN LINE_REFERENCE
, L.LINE_NUMBER SERVICE_LINE_NUMBER
, X.DESCRIPTION SERVICE_NAME
, I.OBJECT1_ID1 OBJECT1_ID1
, I.OBJECT1_ID2 OBJECT1_ID2
, L.START_DATE SERVICE_START_DATE
, L.END_DATE SERVICE_END_DATE
, C.NAME CUSTOMER_ACCOUNT_NAME
, BTO.DESCRIPTION LINE_BTO_ADDRESS
, STO.DESCRIPTION LINE_STO_ADDRESS
FROM OKC_K_LINES_V L
, OKC_K_ITEMS I
, OKX_SYSTEM_ITEMS_V X
, OKX_CUSTOMER_ACCOUNTS_V C
, OKX_CUST_SITE_USES_V BTO
, OKX_CUST_SITE_USES_V STO
WHERE L.LSE_ID IN (1
, 12
, 14
, 19)
AND L.CLE_ID IS NULL
AND L.CHR_ID IS NOT NULL
AND L.ID = I.CLE_ID
AND X.ID1 = I.OBJECT1_ID1
AND X.ID2 = I.OBJECT1_ID2
AND C.ID1(+) = L.CUST_ACCT_ID
AND BTO.ID1(+) = L.BILL_TO_SITE_USE_ID
AND STO.ID1(+) = L.SHIP_TO_SITE_USE_ID