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.

APPS.CS_SERVICEREQUEST_PUB dependencies on OKC_K_LINES_B

Line 6485: okc_k_lines_b svl

6481: party.primary_phone_number customerphone
6482: ,party.email_address CustomerEmail
6483: ,(select hdr.contract_number
6484: from okc_k_headers_all_b hdr,
6485: okc_k_lines_b svl
6486: where hdr.id = svl.chr_id
6487: and hdr.id = svl.dnz_chr_id
6488: and hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')
6489: and svl.id = inc.contract_service_id) ContractNumber

Line 6491: from okc_k_lines_b svl,

6487: and hdr.id = svl.dnz_chr_id
6488: and hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')
6489: and svl.id = inc.contract_service_id) ContractNumber
6490: ,(select mtl.description
6491: from okc_k_lines_b svl,
6492: okc_k_items cim,
6493: mtl_system_items_b mtl
6494: where svl.id = cim.cle_id
6495: and cim.object1_id1 = mtl.inventory_item_id

Line 6499: from okc_k_lines_b svl,

6495: and cim.object1_id1 = mtl.inventory_item_id
6496: and cim.object1_id2 = mtl.organization_id
6497: and svl.id = inc.contract_service_id) ContractServiceDescription
6498: ,(select covt.item_description
6499: from okc_k_lines_b svl,
6500: okc_k_lines_tl covt,
6501: okc_k_lines_b covb,
6502: oks_k_lines_b okssrv
6503: where okssrv.cle_id = svl.id

Line 6501: okc_k_lines_b covb,

6497: and svl.id = inc.contract_service_id) ContractServiceDescription
6498: ,(select covt.item_description
6499: from okc_k_lines_b svl,
6500: okc_k_lines_tl covt,
6501: okc_k_lines_b covb,
6502: oks_k_lines_b okssrv
6503: where okssrv.cle_id = svl.id
6504: and covb.id = okssrv.coverage_id
6505: and covb.lse_id in (2,15,20)