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_CONTRACT_STATUSES

Line 101: CS_Contract_Statuses STAT,

97: FROM CS_Contracts CONT,
98: Cs_Coverages COV,
99: Cs_Coverages COV2,
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,

Line 105: CS_Contract_Statuses STAT2,

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
109: AND CL.Cp_Service_Id = SERV.Cp_Service_Id

Line 350: CS_Contract_Statuses STAT,

346: FROM CS_Contracts CONT,
347: Cs_Coverages COV,
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

Line 353: CS_Contract_Statuses STAT2,

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
357: AND SERV.Contract_Id = CONT.Contract_Id

Line 598: CS_Contract_Statuses STAT,

594: SERV.End_Date_Active SERVICE_END_DATE,
595: COV2.Coverage_Id COVERAGE_ID,
596: COV2.Name COVERAGE
597: FROM CS_Contracts CONT,
598: CS_Contract_Statuses STAT,
599: Cs_Coverages COV,
600: Cs_Coverages COV2,
601: Cs_Coverage_Txn_Groups CTG,
602: Cs_Contract_Cov_Levels CL,

Line 604: CS_Contract_Statuses STAT2,

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
608: AND SERV.Contract_Id = CONT.Contract_Id