VIEW: APPS.OKS_LINES_V

Source

View Text - Preformatted

SELECT l.dnz_chr_id contract_id , l.id line_id , l.name Service_Name , l.start_date Service_Start_Date , l.end_date Service_End_Date , c.name Customer_Account_Name , bto.address1 bill2_Address1 , bto.address2 bill2_Address2 , bto.Country bill2_Country , Null Ship2_Address1 , Null Ship2_Address2 , Null Ship2_Country From okc_k_headers_v k , Okc_k_lines_v l , Okx_customer_accounts_v c , OKX_CUST_SITE_USES_V bto WHERE k.id = l.dnz_chr_id And l.lse_id in (1,19) And c.id1 = l.cust_acct_id And bto.id1(+) = l.bill_to_site_use_id

View Text - HTML Formatted

SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.ID LINE_ID
, L.NAME SERVICE_NAME
, L.START_DATE SERVICE_START_DATE
, L.END_DATE SERVICE_END_DATE
, C.NAME CUSTOMER_ACCOUNT_NAME
, BTO.ADDRESS1 BILL2_ADDRESS1
, BTO.ADDRESS2 BILL2_ADDRESS2
, BTO.COUNTRY BILL2_COUNTRY
, NULL SHIP2_ADDRESS1
, NULL SHIP2_ADDRESS2
, NULL SHIP2_COUNTRY
FROM OKC_K_HEADERS_V K
, OKC_K_LINES_V L
, OKX_CUSTOMER_ACCOUNTS_V C
, OKX_CUST_SITE_USES_V BTO
WHERE K.ID = L.DNZ_CHR_ID
AND L.LSE_ID IN (1
, 19)
AND C.ID1 = L.CUST_ACCT_ID
AND BTO.ID1(+) = L.BILL_TO_SITE_USE_ID