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_GET_CONTRACTS_PUB dependencies on CS_CP_SERVICES

Line 106: Cs_Cp_Services SERV

102: Cs_Covered_Products COVPROD,
103: Cs_Contract_Cov_Levels CL,
104: Mtl_System_Items_Kfv MTL,
105: CS_Contract_Statuses STAT2,
106: Cs_Cp_Services SERV
107: WHERE COVPROD.Customer_Product_Id = P_Customer_Product_Id
108: AND COVPROD.Coverage_Level_Id = CL.Coverage_Level_Id
109: AND CL.Cp_Service_Id = SERV.Cp_Service_Id
110: AND SERV.Contract_Id = CONT.Contract_Id

Line 354: Cs_Cp_Services SERV

350: CS_Contract_Statuses STAT,
351: Cs_Contract_Cov_Levels CL,
352: Mtl_System_Items_Kfv MTL,
353: CS_Contract_Statuses STAT2,
354: Cs_Cp_Services SERV
355: WHERE CL.Coverage_Level_Value = P_Coverage_level_value
356: AND CL.Cp_Service_Id = SERV.Cp_Service_Id
357: AND SERV.Contract_Id = CONT.Contract_Id
358: AND SERV.Coverage_Schedule_Id = COV.Coverage_Id

Line 605: Cs_Cp_Services SERV

601: Cs_Coverage_Txn_Groups CTG,
602: Cs_Contract_Cov_Levels CL,
603: Mtl_System_Items_Kfv MTL,
604: CS_Contract_Statuses STAT2,
605: Cs_Cp_Services SERV
606: WHERE CL.Coverage_Level_Value IN (P_System_Id, P_Site_Use_Id)
607: AND CL.Cp_Service_Id = SERV.Cp_Service_Id
608: AND SERV.Contract_Id = CONT.Contract_Id
609: AND SERV.Coverage_Schedule_Id = COV.Coverage_Id