View: OKS_ENT_TXN_GROUPS_V

Product:	OKS - Service Contracts
Description:	List of transaction groups covered under coverage.
Implementation/DBA Data:	APPS.OKS_ENT_TXN_GROUPS_V

View Text

SELECT KL.ID TXN_GROUP_ID
, KL.CLE_ID COVERAGE_ID
, BP.ID1 BUSINESS_PROCESS_ID
, BP.NAME BUSINESS_PROCESS_NAME
, CV.START_DATE START_DATE
, CV.END_DATE END_DATE
, NULL BILLING_PROFILE_ID
FROM OKC_K_LINES_B SV
, OKC_K_LINES_B CV
, OKC_K_LINES_B KL
, OKC_K_ITEMS IT
, OKX_BUS_PROCESSES_V BP
WHERE SV.ID = CV.CLE_ID
AND CV.ID = KL.CLE_ID
AND KL.LSE_ID IN (3
, 16
, 21)
AND KL.ID = IT.CLE_ID
AND IT.OBJECT1_ID1 = BP.ID1
AND IT.OBJECT1_ID2 = BP.ID2

Columns