[Home] [Help]
| Product: | OKL - Leasing and Finance Management |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.OKL_CURE_RULE_UV
|
SELECT VENDOR_ID
, VENDOR_NAME
, VENDOR_PROGRAM_ID
, VENDOR_PROGRAM_NUMBER
, VENDOR_PROGRAM_NAME
, CONTRACT_ID
, CONTRACT_NUMBER
, CONTRACT_DESCRIPTION
, RULE_CODE
, RULE_INFORMATION1
, RULE_INFORMATION2
, RULE_INFORMATION3
, RULE_INFORMATION4
, TO_DATE(RULE_INFORMATION5 || TO_CHAR(SYSDATE
, '-MM-RRRR')
, 'DD-MM-RRRR') RULE_INFORMATION5
, RULE_INFORMATION6 RULE_INFORMATION6
, TO_DATE(RULE_INFORMATION7 || TO_CHAR(SYSDATE
, '-MM-RRRR')
, 'DD-MM-RRRR') RULE_INFORMATION7
, RULE_INFORMATION8
, RULE_INFORMATION9
, RULE_INFORMATION10
, RULE_INFORMATION11
, RULE_INFORMATION12
, RULE_INFORMATION13
, RULE_INFORMATION14
, RULE_INFORMATION15
FROM OKL_C_V_RULES_UV CVR
WHERE CVR.RULE_CODE = 'COCURE'