[Home] [Help]
View: OKL_LA_PAYMENT_HEADERS_UV
Product: | OKL - Lease and Finance Management |
Description: | User interface view for payment headers |
Implementation/DBA Data: |
APPS.OKL_LA_PAYMENT_HEADERS_UV
|
View Text
SELECT RG.ID RULE_GROUP_ID
, RG.DNZ_CHR_ID DNZ_CHR_ID
, RG.CHR_ID CHR_ID
, RG.CLE_ID CLE_ID
, SLH.ID SLH_ID
, SLH.OBJECT1_ID1 PAYMENT_ID
FROM OKC_RULE_GROUPS_B RG
, OKC_RULES_B SLH
WHERE SLH.DNZ_CHR_ID = RG.DNZ_CHR_ID
AND SLH.RGP_ID = RG.ID
AND SLH.RULE_INFORMATION_CATEGORY = 'LASLH'
Columns
Name |
RULE_GROUP_ID |
DNZ_CHR_ID |
CHR_ID |
CLE_ID |
SLH_ID |
PAYMENT_ID |