VIEW: APPS.OKL_POOL_STREAMS_PAY_UV

Source

View Text - Preformatted

SELECT STMB.KHR_ID KHR_ID , STMB.KLE_ID KLE_ID , STMB.STY_ID STY_ID , STYV.CODE STREAM_TYPE_CODE , STYV.NAME STREAM_TYPE_NAME , STYV.STREAM_TYPE_SUBCLASS , STMB.SAY_CODE STREAM_SAY_CODE , STMB.ACTIVE_YN STREAM_ACTIVE_YN , SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DUE_DATE , SELB.AMOUNT STREAM_ELEMENT_AMOUNT , SELB.DATE_BILLED STREAM_ELEMENT_DATE_BILLED , TUOM.NAME PAYMENT_FREQ, STMB.ID STM_ID FROM OKL_STREAMS STMB,OKL_STRM_ELEMENTS SELB,OKL_STRM_TYPE_V STYV,OKL_TIME_UNITS_V TUOM,OKC_RULES_B SLLB,OKC_RULES_B SLHB,OKC_RULE_GROUPS_B RGPB WHERE STMB.ID = SELB.STM_ID AND STMB.STY_ID = STYV.ID AND RGPB.CLE_ID = STMB.KLE_ID AND TUOM.ID1 = SLLB.OBJECT1_ID1 AND SLLB.OBJECT2_ID1 = TO_CHAR(SLHB.ID) AND SLLB.RGP_ID = RGPB.ID AND SLLB.RULE_INFORMATION_CATEGORY = 'LASLL' AND STMB.STY_ID = SLHB.OBJECT1_ID1 AND SLHB.RGP_ID = RGPB.ID AND SLHB.RULE_INFORMATION_CATEGORY = 'LASLH' AND RGPB.RGD_CODE = 'LALEVL' AND SLLB.RULE_INFORMATION2 IS NOT NULL

View Text - HTML Formatted

SELECT STMB.KHR_ID KHR_ID
, STMB.KLE_ID KLE_ID
, STMB.STY_ID STY_ID
, STYV.CODE STREAM_TYPE_CODE
, STYV.NAME STREAM_TYPE_NAME
, STYV.STREAM_TYPE_SUBCLASS
, STMB.SAY_CODE STREAM_SAY_CODE
, STMB.ACTIVE_YN STREAM_ACTIVE_YN
, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DUE_DATE
, SELB.AMOUNT STREAM_ELEMENT_AMOUNT
, SELB.DATE_BILLED STREAM_ELEMENT_DATE_BILLED
, TUOM.NAME PAYMENT_FREQ
, STMB.ID STM_ID
FROM OKL_STREAMS STMB
, OKL_STRM_ELEMENTS SELB
, OKL_STRM_TYPE_V STYV
, OKL_TIME_UNITS_V TUOM
, OKC_RULES_B SLLB
, OKC_RULES_B SLHB
, OKC_RULE_GROUPS_B RGPB
WHERE STMB.ID = SELB.STM_ID
AND STMB.STY_ID = STYV.ID
AND RGPB.CLE_ID = STMB.KLE_ID
AND TUOM.ID1 = SLLB.OBJECT1_ID1
AND SLLB.OBJECT2_ID1 = TO_CHAR(SLHB.ID)
AND SLLB.RGP_ID = RGPB.ID
AND SLLB.RULE_INFORMATION_CATEGORY = 'LASLL'
AND STMB.STY_ID = SLHB.OBJECT1_ID1
AND SLHB.RGP_ID = RGPB.ID
AND SLHB.RULE_INFORMATION_CATEGORY = 'LASLH'
AND RGPB.RGD_CODE = 'LALEVL'
AND SLLB.RULE_INFORMATION2 IS NOT NULL