[Home] [Help]
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
Name |
TXN_GROUP_ID |
COVERAGE_ID |
BUSINESS_PROCESS_ID |
BUSINESS_PROCESS_NAME |
START_DATE |
END_DATE |
BILLING_PROFILE_ID |