VIEW: APPS.OKS_ENT_TXN_GROUPS_V

Source

View Text - Preformatted

SELECT SV.ID CONTRACT_LINE_ID, KL.ID TXN_GROUP_ID , KL.CLE_ID COVERAGE_ID , BP.ID1 BUSINESS_PROCESS_ID , BP.NAME BUSINESS_PROCESS_NAME , DECODE(OKSSV.STANDARD_COV_YN,'Y' ,OKS_ENTITLEMENTS_PVT.Get_BPL_Offset_Start_Date(SV.START_DATE, OKSKL.Offset_period,OKSKL.Offset_Duration) ,KL.START_DATE) START_DATE , DECODE(OKSSV.STANDARD_COV_YN,'Y',SV.END_DATE ,KL.END_DATE) END_DATE ,NULL BILLING_PROFILE_ID FROM OKC_K_LINES_B SV , OKS_K_LINES_B OKSSV, OKC_K_LINES_B KL , OKS_K_LINES_B OKSKL, OKC_K_ITEMS IT , OKX_BUS_PROCESSES_V BP WHERE SV.ID = OKSSV.CLE_ID AND SV.LSE_ID IN (1,14,19) AND KL.CLE_ID = OKSSV.COVERAGE_ID AND KL.LSE_ID IN (3,16,21) AND OKSKL.CLE_ID = KL.ID AND KL.ID = IT.CLE_ID AND IT.OBJECT1_ID1 = BP.ID1 AND IT.OBJECT1_ID2 = BP.ID2

View Text - HTML Formatted

SELECT SV.ID CONTRACT_LINE_ID
, KL.ID TXN_GROUP_ID
, KL.CLE_ID COVERAGE_ID
, BP.ID1 BUSINESS_PROCESS_ID
, BP.NAME BUSINESS_PROCESS_NAME
, DECODE(OKSSV.STANDARD_COV_YN
, 'Y'
, OKS_ENTITLEMENTS_PVT.GET_BPL_OFFSET_START_DATE(SV.START_DATE
, OKSKL.OFFSET_PERIOD
, OKSKL.OFFSET_DURATION)
, KL.START_DATE) START_DATE
, DECODE(OKSSV.STANDARD_COV_YN
, 'Y'
, SV.END_DATE
, KL.END_DATE) END_DATE
, NULL BILLING_PROFILE_ID
FROM OKC_K_LINES_B SV
, OKS_K_LINES_B OKSSV
, OKC_K_LINES_B KL
, OKS_K_LINES_B OKSKL
, OKC_K_ITEMS IT
, OKX_BUS_PROCESSES_V BP
WHERE SV.ID = OKSSV.CLE_ID
AND SV.LSE_ID IN (1
, 14
, 19)
AND KL.CLE_ID = OKSSV.COVERAGE_ID
AND KL.LSE_ID IN (3
, 16
, 21)
AND OKSKL.CLE_ID = KL.ID
AND KL.ID = IT.CLE_ID
AND IT.OBJECT1_ID1 = BP.ID1
AND IT.OBJECT1_ID2 = BP.ID2