[Home] [Help]
View: OKL_CS_TRX_CONTRACTS_UV
Product: | OKL - Lease and Finance Management |
Description: | View to display Service Contracts |
Implementation/DBA Data: |
APPS.OKL_CS_TRX_CONTRACTS_UV
|
View Text
SELECT TRX.KHR_ID HEADER_CONTRACT_ID
, TRX.DATE_TRANSACTION_OCCURRED TRANSACTION_DATE
, TRX.TSU_CODE TRANSACTION_TYPE_CODE
, LOOKUP.MEANING TRANSACTION_TYPE_DESC
, TRX.TRX_NUMBER TRANSACTION_NUMBER
, TRX.CHR_ID SERVICE_CONTRACT_ID
, TRX.DESCRIPTION TRX_DESCRIPTION
, TRX.ID TRX_ID
, TRX.TRY_ID TRY_ID
FROM OKL_TRX_CONTRACTS TRX
, FND_LOOKUPS LOOKUP
WHERE TCN_TYPE = 'SER'
AND LOOKUP.LOOKUP_TYPE = 'OKL_TRANSACTION_STATUS'
AND TRX.TSU_CODE = LOOKUP.LOOKUP_CODE ORDER BY TRX_NUMBER DESC
Columns
Name |
HEADER_CONTRACT_ID |
TRANSACTION_DATE |
TRANSACTION_TYPE_CODE |
TRANSACTION_TYPE_DESC |
TRANSACTION_NUMBER |
SERVICE_CONTRACT_ID |
TRX_DESCRIPTION |
TRX_ID |
TRY_ID |