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 MTL_SYSTEM_ITEMS_KFV

Line 104: Mtl_System_Items_Kfv MTL,

100: Cs_Coverage_Txn_Groups CTG,
101: CS_Contract_Statuses STAT,
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

Line 352: Mtl_System_Items_Kfv MTL,

348: Cs_Coverages COV2,
349: Cs_Coverage_Txn_Groups CTG,
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

Line 603: Mtl_System_Items_Kfv MTL,

599: Cs_Coverages COV,
600: Cs_Coverages COV2,
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