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.

VIEW: APPS.OKL_POOL_CONTRACTS_UV

Source

View Text - Preformatted


SELECT CHRB.ID DNZ_CHR_ID, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER, KHRB.PRE_TAX_YIELD PRE_TAX_YIELD, KHRB.DEAL_TYPE BOOK_CLASSIFICATION, KHRB.PDT_ID PDT_ID, KHRB.ASSIGNABLE_YN ASSIGNABLE_YN, CHRB.STS_CODE STS_CODE , CHRB.START_DATE START_DATE, CHRB.END_DATE END_DATE, CHRB.AUTHORING_ORG_ID OPERATING_UNIT, CHRB.CURRENCY_CODE CURRENCY_CODE , CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID, RULB.RULE_INFORMATION1 TAX_OWNER FROM OKC_K_HEADERS_B CHRB,OKL_K_HEADERS KHRB,OKC_RULE_GROUPS_B RGPB,OKC_RULES_B RULB WHERE CHRB.ID = KHRB.ID AND CHRB.ID = RGPB.DNZ_CHR_ID AND CHRB.ID = RULB.DNZ_CHR_ID AND RGPB.ID = RULB.RGP_ID AND RULB.RULE_INFORMATION_CATEGORY= 'LATOWN'

View Text - HTML Formatted

SELECT CHRB.ID DNZ_CHR_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, KHRB.PRE_TAX_YIELD PRE_TAX_YIELD
, KHRB.DEAL_TYPE BOOK_CLASSIFICATION
, KHRB.PDT_ID PDT_ID
, KHRB.ASSIGNABLE_YN ASSIGNABLE_YN
, CHRB.STS_CODE STS_CODE
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, CHRB.AUTHORING_ORG_ID OPERATING_UNIT
, CHRB.CURRENCY_CODE CURRENCY_CODE
, CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID
, RULB.RULE_INFORMATION1 TAX_OWNER
FROM OKC_K_HEADERS_B CHRB
, OKL_K_HEADERS KHRB
, OKC_RULE_GROUPS_B RGPB
, OKC_RULES_B RULB
WHERE CHRB.ID = KHRB.ID
AND CHRB.ID = RGPB.DNZ_CHR_ID
AND CHRB.ID = RULB.DNZ_CHR_ID
AND RGPB.ID = RULB.RGP_ID
AND RULB.RULE_INFORMATION_CATEGORY= 'LATOWN'