[Home] [Help]
View: OKL_LA_PAYMENT_HEADERS_UV
| Product: | OKL - Leasing 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 |