eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKS_PROD_DETAILS_V

Source

View Text - Preformatted


SELECT l.dnz_chr_id CONTRACT_ID ,l.cle_id LINE_ID ,l.id COVD_LINE_ID ,l.line_number COVD_LINE_NUMBER ,l.lse_id COVD_LINE_LSE_ID ,ls.name COVRED_LEVEL ,NULL COVERED_SYSTEM ,(select cp.current_serial_number from cs_customer_products_all cp where cp.customer_product_id = it.object1_id1) COVERED_SERIAL_NO ,sx.description COVD_DESCRIPTION ,it.object1_id1 OBJECT_ID ,it.number_of_items QUANTITY ,it.uom_code QTY_UOM ,l.price_negotiated PRICE FROM okc_k_headers_b k ,okc_k_lines_b l ,okc_line_styles_tl ls ,okc_k_items it ,okx_system_items_v sx ,cs_customer_products cp WHERE l.lse_id in (9,18,25) And l.lse_id = ls.id And ls.language = USERENV('LANG') and l.dnz_chr_id = it.dnz_chr_id And l.id = it.cle_id And l.cle_id is not null And l.dnz_chr_id = k.id And k.inv_organization_id = sx.id2 And sx.id1 = cp.inventory_item_id And cp.customer_product_id = it.object1_id1 union select l.dnz_chr_id contract_id ,l.cle_id line_id ,l.id COVD_LINE_ID ,l.line_number COVD_LINE_NUMBER ,l.lse_id COVD_LINE_LSE_ID ,ls.name COVERED_LEVEL ,NULL COVERED_SYSTEM ,NULL COVERED_SERIAL_NO ,sx.description COVD_DESCRIPTION ,it.object1_id1 OBJECT_ID ,it.number_of_items QUANTITY ,it.uom_code QTY_UOM ,l.price_negotiated PRICE From Okc_k_lines_b l , Okc_line_styles_tl ls , Okc_k_items it, OKX_CUSTOMER_ACCOUNTS_V sx WHERE l.lse_id in (35) And l.lse_id = ls.id And ls.language = USERENV('LANG') and l.dnz_chr_id = it.dnz_chr_id And l.id = it.cle_id And l.cle_id is not null And sx.id1 = it.object1_id1 union select l.dnz_chr_id contract_id ,l.cle_id line_id ,l.id COVD_LINE_ID ,l.line_number COVD_LINE_NUMBER ,l.lse_id COVD_LINE_LSE_ID ,ls.name COVERED_LEVEL ,NULL COVERED_SYSTEM ,NULL COVERED_SERIAL_NO ,sx.description COVD_DESCRIPTION ,it.object1_id1 OBJECT_ID ,it.number_of_items QUANTITY ,it.uom_code QTY_UOM ,l.price_negotiated PRICE From okc_k_headers_b k, Okc_k_lines_b l , Okc_line_styles_tl ls , Okc_k_items it, OKX_SYSTEM_ITEMS_V sx WHERE l.lse_id in (7) And l.lse_id = ls.id And ls.language = USERENV('LANG') and l.dnz_chr_id = it.dnz_chr_id And l.id = it.cle_id And l.cle_id is not null And l.dnz_chr_id = k.id And k.inv_organization_id = sx.id2 And sx.id1 = it.object1_id1 AND sx.id2 = it.object1_id2 UNION select l.dnz_chr_id contract_id ,l.cle_id line_id ,l.id COVD_LINE_ID ,l.line_number COVD_LINE_NUMBER ,l.lse_id COVD_LINE_LSE_ID ,ls.name COVERED_LEVEL ,NULL COVERED_SYSTEM ,NULL COVERED_SERIAL_NO ,sx.description COVD_DESCRIPTION ,it.object1_id1 OBJECT_ID ,it.number_of_items QUANTITY ,it.uom_code QTY_UOM ,l.price_negotiated PRICE From Okc_k_lines_b l , Okc_line_styles_tl ls , Okc_k_items it, OKX_PARTIES_V sx WHERE l.lse_id in (8) And l.lse_id = ls.id And ls.language = USERENV('LANG') and l.dnz_chr_id = it.dnz_chr_id And l.id = it.cle_id And l.cle_id is not null And sx.id1 = it.object1_id1 union select l.dnz_chr_id contract_id ,l.cle_id line_id ,l.id COVD_LINE_ID ,l.line_number COVD_LINE_NUMBER ,l.lse_id COVD_LINE_LSE_ID ,ls.name COVERED_LEVEL ,NULL COVERED_SYSTEM ,NULL COVERED_SERIAL_NO ,sx.description COVD_DESCRIPTION ,it.object1_id1 OBJECT_ID ,it.number_of_items QUANTITY ,it.uom_code QTY_UOM ,l.price_negotiated PRICE From okc_k_headers_b k, Okc_k_lines_b l , Okc_line_styles_tl ls , Okc_k_items it, OKX_CUST_SITE_USES_V sx WHERE l.lse_id in (10) And l.lse_id = ls.id And ls.language = USERENV('LANG') and l.dnz_chr_id = it.dnz_chr_id And l.id = it.cle_id And l.cle_id is not null And l.dnz_chr_id = k.id And k.authoring_org_id = sx.org_id And sx.id1 = it.object1_id1 union select l.dnz_chr_id contract_id ,l.cle_id line_id ,l.id COVD_LINE_ID ,l.line_number COVD_LINE_NUMBER ,l.lse_id COVD_LINE_LSE_ID ,ls.name COVERED_LEVEL ,sx.NAME COVERED_SYSTEM ,NULL COVERED_SERIAL_NO ,sx.description COVD_DESCRIPTION ,it.object1_id1 OBJECT_ID ,it.number_of_items QUANTITY ,it.uom_code QTY_UOM ,l.price_negotiated PRICE From okc_k_headers_b k, Okc_k_lines_b l , Okc_line_styles_tl ls , Okc_k_items it, OKX_SYSTEMS_V sx WHERE l.lse_id in (11) And l.lse_id = ls.id And ls.language = USERENV('LANG') and l.dnz_chr_id = it.dnz_chr_id And l.id = it.cle_id And l.cle_id is not null And l.dnz_chr_id = k.id And k.authoring_org_id = sx.org_id And sx.id1 = it.object1_id1

View Text - HTML Formatted

SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.CLE_ID LINE_ID
, L.ID COVD_LINE_ID
, L.LINE_NUMBER COVD_LINE_NUMBER
, L.LSE_ID COVD_LINE_LSE_ID
, LS.NAME COVRED_LEVEL
, NULL COVERED_SYSTEM
, (SELECT CP.CURRENT_SERIAL_NUMBER
FROM CS_CUSTOMER_PRODUCTS_ALL CP
WHERE CP.CUSTOMER_PRODUCT_ID = IT.OBJECT1_ID1) COVERED_SERIAL_NO
, SX.DESCRIPTION COVD_DESCRIPTION
, IT.OBJECT1_ID1 OBJECT_ID
, IT.NUMBER_OF_ITEMS QUANTITY
, IT.UOM_CODE QTY_UOM
, L.PRICE_NEGOTIATED PRICE
FROM OKC_K_HEADERS_B K
, OKC_K_LINES_B L
, OKC_LINE_STYLES_TL LS
, OKC_K_ITEMS IT
, OKX_SYSTEM_ITEMS_V SX
, CS_CUSTOMER_PRODUCTS CP
WHERE L.LSE_ID IN (9
, 18
, 25)
AND L.LSE_ID = LS.ID
AND LS.LANGUAGE = USERENV('LANG')
AND L.DNZ_CHR_ID = IT.DNZ_CHR_ID
AND L.ID = IT.CLE_ID
AND L.CLE_ID IS NOT NULL
AND L.DNZ_CHR_ID = K.ID
AND K.INV_ORGANIZATION_ID = SX.ID2
AND SX.ID1 = CP.INVENTORY_ITEM_ID
AND CP.CUSTOMER_PRODUCT_ID = IT.OBJECT1_ID1 UNION SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.CLE_ID LINE_ID
, L.ID COVD_LINE_ID
, L.LINE_NUMBER COVD_LINE_NUMBER
, L.LSE_ID COVD_LINE_LSE_ID
, LS.NAME COVERED_LEVEL
, NULL COVERED_SYSTEM
, NULL COVERED_SERIAL_NO
, SX.DESCRIPTION COVD_DESCRIPTION
, IT.OBJECT1_ID1 OBJECT_ID
, IT.NUMBER_OF_ITEMS QUANTITY
, IT.UOM_CODE QTY_UOM
, L.PRICE_NEGOTIATED PRICE
FROM OKC_K_LINES_B L
, OKC_LINE_STYLES_TL LS
, OKC_K_ITEMS IT
, OKX_CUSTOMER_ACCOUNTS_V SX
WHERE L.LSE_ID IN (35)
AND L.LSE_ID = LS.ID
AND LS.LANGUAGE = USERENV('LANG')
AND L.DNZ_CHR_ID = IT.DNZ_CHR_ID
AND L.ID = IT.CLE_ID
AND L.CLE_ID IS NOT NULL
AND SX.ID1 = IT.OBJECT1_ID1 UNION SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.CLE_ID LINE_ID
, L.ID COVD_LINE_ID
, L.LINE_NUMBER COVD_LINE_NUMBER
, L.LSE_ID COVD_LINE_LSE_ID
, LS.NAME COVERED_LEVEL
, NULL COVERED_SYSTEM
, NULL COVERED_SERIAL_NO
, SX.DESCRIPTION COVD_DESCRIPTION
, IT.OBJECT1_ID1 OBJECT_ID
, IT.NUMBER_OF_ITEMS QUANTITY
, IT.UOM_CODE QTY_UOM
, L.PRICE_NEGOTIATED PRICE
FROM OKC_K_HEADERS_B K
, OKC_K_LINES_B L
, OKC_LINE_STYLES_TL LS
, OKC_K_ITEMS IT
, OKX_SYSTEM_ITEMS_V SX
WHERE L.LSE_ID IN (7)
AND L.LSE_ID = LS.ID
AND LS.LANGUAGE = USERENV('LANG')
AND L.DNZ_CHR_ID = IT.DNZ_CHR_ID
AND L.ID = IT.CLE_ID
AND L.CLE_ID IS NOT NULL
AND L.DNZ_CHR_ID = K.ID
AND K.INV_ORGANIZATION_ID = SX.ID2
AND SX.ID1 = IT.OBJECT1_ID1
AND SX.ID2 = IT.OBJECT1_ID2 UNION SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.CLE_ID LINE_ID
, L.ID COVD_LINE_ID
, L.LINE_NUMBER COVD_LINE_NUMBER
, L.LSE_ID COVD_LINE_LSE_ID
, LS.NAME COVERED_LEVEL
, NULL COVERED_SYSTEM
, NULL COVERED_SERIAL_NO
, SX.DESCRIPTION COVD_DESCRIPTION
, IT.OBJECT1_ID1 OBJECT_ID
, IT.NUMBER_OF_ITEMS QUANTITY
, IT.UOM_CODE QTY_UOM
, L.PRICE_NEGOTIATED PRICE
FROM OKC_K_LINES_B L
, OKC_LINE_STYLES_TL LS
, OKC_K_ITEMS IT
, OKX_PARTIES_V SX
WHERE L.LSE_ID IN (8)
AND L.LSE_ID = LS.ID
AND LS.LANGUAGE = USERENV('LANG')
AND L.DNZ_CHR_ID = IT.DNZ_CHR_ID
AND L.ID = IT.CLE_ID
AND L.CLE_ID IS NOT NULL
AND SX.ID1 = IT.OBJECT1_ID1 UNION SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.CLE_ID LINE_ID
, L.ID COVD_LINE_ID
, L.LINE_NUMBER COVD_LINE_NUMBER
, L.LSE_ID COVD_LINE_LSE_ID
, LS.NAME COVERED_LEVEL
, NULL COVERED_SYSTEM
, NULL COVERED_SERIAL_NO
, SX.DESCRIPTION COVD_DESCRIPTION
, IT.OBJECT1_ID1 OBJECT_ID
, IT.NUMBER_OF_ITEMS QUANTITY
, IT.UOM_CODE QTY_UOM
, L.PRICE_NEGOTIATED PRICE
FROM OKC_K_HEADERS_B K
, OKC_K_LINES_B L
, OKC_LINE_STYLES_TL LS
, OKC_K_ITEMS IT
, OKX_CUST_SITE_USES_V SX
WHERE L.LSE_ID IN (10)
AND L.LSE_ID = LS.ID
AND LS.LANGUAGE = USERENV('LANG')
AND L.DNZ_CHR_ID = IT.DNZ_CHR_ID
AND L.ID = IT.CLE_ID
AND L.CLE_ID IS NOT NULL
AND L.DNZ_CHR_ID = K.ID
AND K.AUTHORING_ORG_ID = SX.ORG_ID
AND SX.ID1 = IT.OBJECT1_ID1 UNION SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.CLE_ID LINE_ID
, L.ID COVD_LINE_ID
, L.LINE_NUMBER COVD_LINE_NUMBER
, L.LSE_ID COVD_LINE_LSE_ID
, LS.NAME COVERED_LEVEL
, SX.NAME COVERED_SYSTEM
, NULL COVERED_SERIAL_NO
, SX.DESCRIPTION COVD_DESCRIPTION
, IT.OBJECT1_ID1 OBJECT_ID
, IT.NUMBER_OF_ITEMS QUANTITY
, IT.UOM_CODE QTY_UOM
, L.PRICE_NEGOTIATED PRICE
FROM OKC_K_HEADERS_B K
, OKC_K_LINES_B L
, OKC_LINE_STYLES_TL LS
, OKC_K_ITEMS IT
, OKX_SYSTEMS_V SX
WHERE L.LSE_ID IN (11)
AND L.LSE_ID = LS.ID
AND LS.LANGUAGE = USERENV('LANG')
AND L.DNZ_CHR_ID = IT.DNZ_CHR_ID
AND L.ID = IT.CLE_ID
AND L.CLE_ID IS NOT NULL
AND L.DNZ_CHR_ID = K.ID
AND K.AUTHORING_ORG_ID = SX.ORG_ID
AND SX.ID1 = IT.OBJECT1_ID1