VIEW: APPS.OKS_CUST_PRODUCTS_V

Source

View Text - Preformatted

SELECT distinct kline.cle_id cle_id , kline.start_date effective_start_date , kline.end_date effective_end_date , cprod.name Product_name , cprod.CURRENT_SERIAL_NUMBER current_serial_number , psite.address1||psite.address2||psite.address3||psite.address4 Address , cprod.INSTALLATION_DATE installation_date , cprod.QUANTITY quantity , cprod.UNIT_OF_MEASURE_CODE uom_code , cprod.REFERENCE_NUMBER reference_number , cprod.ORIGINAL_NET_AMOUNT net_amount from okc_k_lines_v kline , okc_k_items_v kitem , okx_customer_products_v cprod , okx_party_site_uses_v psite WHERE kline.lse_id in (9,13) and kline.id = kitem.cle_id and kitem.object1_id1 = cprod.id1 and kitem.object1_id2 = cprod.id2 and cprod.organization_id = sys_context('OKC_CONTEXT','ORGANIZATION_ID') and cprod.install_site_use_id = psite.party_site_id(+)

View Text - HTML Formatted

SELECT DISTINCT KLINE.CLE_ID CLE_ID
, KLINE.START_DATE EFFECTIVE_START_DATE
, KLINE.END_DATE EFFECTIVE_END_DATE
, CPROD.NAME PRODUCT_NAME
, CPROD.CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER
, PSITE.ADDRESS1||PSITE.ADDRESS2||PSITE.ADDRESS3||PSITE.ADDRESS4 ADDRESS
, CPROD.INSTALLATION_DATE INSTALLATION_DATE
, CPROD.QUANTITY QUANTITY
, CPROD.UNIT_OF_MEASURE_CODE UOM_CODE
, CPROD.REFERENCE_NUMBER REFERENCE_NUMBER
, CPROD.ORIGINAL_NET_AMOUNT NET_AMOUNT
FROM OKC_K_LINES_V KLINE
, OKC_K_ITEMS_V KITEM
, OKX_CUSTOMER_PRODUCTS_V CPROD
, OKX_PARTY_SITE_USES_V PSITE
WHERE KLINE.LSE_ID IN (9
, 13)
AND KLINE.ID = KITEM.CLE_ID
AND KITEM.OBJECT1_ID1 = CPROD.ID1
AND KITEM.OBJECT1_ID2 = CPROD.ID2
AND CPROD.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT'
, 'ORGANIZATION_ID')
AND CPROD.INSTALL_SITE_USE_ID = PSITE.PARTY_SITE_ID(+)