DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PUB dependencies on OKC_K_ITEMS

Line 6492: okc_k_items cim,

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
6496: and cim.object1_id2 = mtl.organization_id