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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OKL.OKL_TRX_CONTRACTS_ALL

Object Details

Object Name:	OKL_TRX_CONTRACTS_ALL
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_TRX_CONTRACTS_ALL
Subobject Name:
Status:	VALID

This is the main transaction table of OKL and contains transaction header data for various categories of transactions. The various categories are 'Accrual', 'Booking', 'General Loss Provision', 'Miscellaneous', 'Rebook', 'Reverse', 'Specific Loss Provision', 'Split Contract', 'Syndication Agreement', 'Termination', 'Transfer and Assumption'. These different transaction categories are identified by field TCN_TYPE. This is a transaction header table and its corresponding line table is OKL_TXL_CNTRCT_LNS. This table is stripped by operating unit.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_TRX_CONTRACTS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REPRESENTATION_CODE TRX_NUMBER ORG_ID
OKL_TRX_CONTRACTS_ALL_U2	NORMAL	UNIQUE	APPS_TS_NOLOGGING	ID
OKL_TRX_CONTRACTS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AES_ID
OKL_TRX_CONTRACTS_ALL_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RPY_CODE
OKL_TRX_CONTRACTS_ALL_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RVN_CODE
OKL_TRX_CONTRACTS_ALL_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRN_CODE
OKL_TRX_CONTRACTS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID
OKL_TRX_CONTRACTS_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KHR_ID
OKL_TRX_CONTRACTS_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KHR_ID_NEW
OKL_TRX_CONTRACTS_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KHR_ID_OLD
OKL_TRX_CONTRACTS_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PDT_ID
OKL_TRX_CONTRACTS_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PVN_ID
OKL_TRX_CONTRACTS_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QTE_ID
OKL_TRX_CONTRACTS_ALL_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RBR_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
TRX_NUMBER	VARCHAR2	(30)	Yes	Transaction Number. If user does not specify a value, it is generated through a sequence
KHR_ID_NEW	NUMBER			New Contract Header ID
KHR_ID_OLD	NUMBER			Old Contract Header ID
KHR_ID	NUMBER			Foreign key to table OKL_K_HEADERS
PVN_ID	NUMBER			Foreign key to table OKL_PROVISIONS
PDT_ID	NUMBER			Foreign key to table OKL_PRODUCTS
RBR_CODE	VARCHAR2	(30)		Rebook reason code. Points to FND lookup OKL_REBOOK_REASON
RPY_CODE	VARCHAR2	(30)		Rebook process type. Points to FND lookup OKL_REBOOK_PROCESS_TYPE
RVN_CODE	VARCHAR2	(30)		Unique identifier for reverse reason. Points to FND lookup OKL_REVERSE_REASON
TRN_CODE	VARCHAR2	(30)		Termination reason. Points to FND lookup OKL_TERMINATION_REASON
QTE_ID	NUMBER			Foreign key to table OKL_TRX_QUOTES_B
AES_ID	NUMBER			Foreign key to table OKL_AE_TMPT_SETS
CODE_COMBINATION_ID	NUMBER			Key flexfield combination defining column
TRY_ID	NUMBER		Yes	Foreign key to table OKL_TRX_TYPES_B
TSU_CODE	VARCHAR2	(30)	Yes	Transaction status code. Points to FND lookup OKL_TRANSACTION_STATUS
SET_OF_BOOKS_ID	NUMBER			Accounting books defining column
TCN_TYPE	VARCHAR2	(10)	Yes	Transaction category. Valid values are ACL, BKG, MAE, PGL, PSP, RVC, SIN, SPLC, TAA, TMT, TRBK. Points to FND lookup OKL_TCN_TYPE
DESCRIPTION	VARCHAR2	(1995)		User entered description
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
DATE_ACCRUAL	DATE			Date of accrual. I.e. date of recognition of income. Can be different than accrual transaction date.
DATE_TRANSACTION_OCCURRED	DATE		Yes	Transaction date
ACCRUAL_STATUS_YN	VARCHAR2	(3)		Indicates the status of the accrual rule for the contract
UPDATE_STATUS_YN	VARCHAR2	(3)		Override status of the accrual transaction. user can prevent the recognition of income by overriding the accrual process by checking the override flag. Examples: Y, N
TAX_DEDUCTIBLE_LOCAL	VARCHAR2	(3)		Local tax deductibility status. No processing is currently driven off this field
TAX_DEDUCTIBLE_CORPORATE	VARCHAR2	(3)		Corporate tax deductibility status. No processing is currently driven off this field
AMOUNT	NUMBER	(14)		Transaction Amount
CURRENCY_CODE	VARCHAR2	(150)		Currency code
TMT_EVERGREEN_YN	VARCHAR2	(3)		Used for Termination transactions to indicate whether the contract was put into Evergreen status.
TMT_CLOSE_BALANCES_YN	VARCHAR2	(3)		Used for Termination transactions to indicate whether any open AR balances were written off.
TMT_ACCOUNTING_ENTRIES_YN	VARCHAR2	(3)		Used for Termination transactions to indicate whether any accounting entries are created
TMT_CANCEL_INSURANCE_YN	VARCHAR2	(3)		Used for Termination transactions to indicate whether any contract insurances were cancelled.
TMT_ASSET_DISPOSITION_YN	VARCHAR2	(3)		Used for Termination transactions to indicate whether the asset disposition process was successful
TMT_AMORTIZATION_YN	VARCHAR2	(3)		Used for Termination transactions to indicate whether any off-lease asset transactions were created
TMT_ASSET_RETURN_YN	VARCHAR2	(3)		Used for Termination transactions to indicate whether any asset returns were created
TMT_CONTRACT_UPDATED_YN	VARCHAR2	(3)		Used for Termination transactions to indicate whether the contract status was updated
TMT_RECYCLE_YN	VARCHAR2	(3)		Used for Termination transactions to indicate whether this transaction is flagged for recycling
TMT_VALIDATED_YN	VARCHAR2	(3)		Used for Termination transactions to indicate whether the contract is validated
TMT_STREAMS_UPDATED_YN	VARCHAR2	(3)		Used for Termination transactions to indicate whether any future billable streams were inactivated
RJN_CODE	VARCHAR2	(30)		Rejection Code. If the request for transfer and assumption is rejected, this field is populated with appropriate code. The values are derived from lookup type OKL_REJECTION_REASON.
PARTY_REL_ID1_OLD	NUMBER	(15)		Old party relationship identifier
PARTY_REL_ID2_OLD	VARCHAR2	(15)		Old party relationship identifier
PARTY_REL_ID1_NEW	NUMBER	(15)		New party relationship identifier
PARTY_REL_ID2_NEW	VARCHAR2	(15)		New party relationship identifier
COMPLETE_TRANSFER_YN	VARCHAR2	(3)		Complete tranfer flag. If transfer and assumption is for all the assets in the contract then the value would be 'Y' else it would be 'N'
ACCRUAL_ACTIVITY	VARCHAR2	(30)		Denotes the activity of the accrual transaction I.e. whether the transaction is an accrual, non-accrual, reversal or catchup transaction
ATTRIBUTE_CATEGORY	VARCHAR2	(90)		Descriptive flexfield category column
ATTRIBUTE1	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE2	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE3	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE4	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE5	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE6	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE7	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE8	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE9	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE10	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE11	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE12	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE13	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE14	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE15	VARCHAR2	(450)		Descriptive flexfield column
ORG_ID	NUMBER	(15)		Operating unit identifier
REQUEST_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_UPDATE_DATE	DATE			Concurrent Manager column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CHR_ID	NUMBER			Foreign key to table OKL_K_HEADERS
TMT_SPLIT_ASSET_YN	VARCHAR2	(3)		Used by termination transactions to indicate whether the asset split step was successful.
TMT_GENERIC_FLAG1_YN	VARCHAR2	(3)		Used by termination transactions to indicate whether a termination step was successful.
TMT_GENERIC_FLAG2_YN	VARCHAR2	(3)		Used by termination transactions to indicate whether a termination step was successful.
TMT_GENERIC_FLAG3_YN	VARCHAR2	(3)		Used by termination transactions to indicate whether a termination step was successful.
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency Conversion Type used to convert the amount from the transaction currency to functional currency
CURRENCY_CONVERSION_RATE	NUMBER			Currency Conversion Rate used to convert the amount from the transaction currency to functional currency
CURRENCY_CONVERSION_DATE	DATE			Currency Conversion Date used to convert the amount from the transaction currency to functional currency
SOURCE_TRX_ID	NUMBER			Source Transaction Identifier
SOURCE_TRX_TYPE	VARCHAR2	(30)		Source Transaction Table
CANCELED_DATE	DATE			Date on which the transaction is canceled
LEGAL_ENTITY_ID	NUMBER			Stores the Legal Entity Identifier. Foreign Key to XLE_ENTITY_PROFILES
ACCRUAL_REVERSAL_DATE	DATE			Date on which the Accrual Transaction will be reversed
PRODUCT_NAME	VARCHAR2	(150)		Product Name of the Contract or Investor Agreement.
BOOK_CLASSIFICATION_CODE	VARCHAR2	(30)		Contract Book Classification
TAX_OWNER_CODE	VARCHAR2	(150)		Contract Tax Owner
ACCOUNTING_REVERSAL_YN	VARCHAR2	(3)		Accounting Reversal Indicator
TMT_STATUS_CODE	VARCHAR2	(30)		Termination Process Status Indicator. Points to FND lookup OKL_TRANSACTION_STATUS
REPRESENTATION_NAME	VARCHAR2	(30)		Representation Name
REPRESENTATION_CODE	VARCHAR2	(20)		Representation Code
UPGRADE_STATUS_FLAG	VARCHAR2	(1)		This column is added as part of SLA uptake for making Ids sequence generatedThe various values are :NULL - Upgrade required by ID upgrade scriptY - Upgraded by scriptN - Created new and hence uses correct sequence
TRANSACTION_DATE	DATE			Stores the date on which the transaction occurred. Equivalent of the the creation date column and is used in reconciliation reports.
REPRESENTATION_TYPE	VARCHAR2	(9)		Representation Type
PRIMARY_REP_TRX_ID	NUMBER			Primary Representation Transaction Id
TRANSACTION_REVERSAL_DATE	DATE			Transaction Reversal date

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      TRX_NUMBER
,      KHR_ID_NEW
,      KHR_ID_OLD
,      KHR_ID
,      PVN_ID
,      PDT_ID
,      RBR_CODE
,      RPY_CODE
,      RVN_CODE
,      TRN_CODE
,      QTE_ID
,      AES_ID
,      CODE_COMBINATION_ID
,      TRY_ID
,      TSU_CODE
,      SET_OF_BOOKS_ID
,      TCN_TYPE
,      DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      DATE_ACCRUAL
,      DATE_TRANSACTION_OCCURRED
,      ACCRUAL_STATUS_YN
,      UPDATE_STATUS_YN
,      TAX_DEDUCTIBLE_LOCAL
,      TAX_DEDUCTIBLE_CORPORATE
,      AMOUNT
,      CURRENCY_CODE
,      TMT_EVERGREEN_YN
,      TMT_CLOSE_BALANCES_YN
,      TMT_ACCOUNTING_ENTRIES_YN
,      TMT_CANCEL_INSURANCE_YN
,      TMT_ASSET_DISPOSITION_YN
,      TMT_AMORTIZATION_YN
,      TMT_ASSET_RETURN_YN
,      TMT_CONTRACT_UPDATED_YN
,      TMT_RECYCLE_YN
,      TMT_VALIDATED_YN
,      TMT_STREAMS_UPDATED_YN
,      RJN_CODE
,      PARTY_REL_ID1_OLD
,      PARTY_REL_ID2_OLD
,      PARTY_REL_ID1_NEW
,      PARTY_REL_ID2_NEW
,      COMPLETE_TRANSFER_YN
,      ACCRUAL_ACTIVITY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CHR_ID
,      TMT_SPLIT_ASSET_YN
,      TMT_GENERIC_FLAG1_YN
,      TMT_GENERIC_FLAG2_YN
,      TMT_GENERIC_FLAG3_YN
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      SOURCE_TRX_ID
,      SOURCE_TRX_TYPE
,      CANCELED_DATE
,      LEGAL_ENTITY_ID
,      ACCRUAL_REVERSAL_DATE
,      PRODUCT_NAME
,      BOOK_CLASSIFICATION_CODE
,      TAX_OWNER_CODE
,      ACCOUNTING_REVERSAL_YN
,      TMT_STATUS_CODE
,      REPRESENTATION_NAME
,      REPRESENTATION_CODE
,      UPGRADE_STATUS_FLAG
,      TRANSACTION_DATE
,      REPRESENTATION_TYPE
,      PRIMARY_REP_TRX_ID
,      TRANSACTION_REVERSAL_DATE
FROM OKL.OKL_TRX_CONTRACTS_ALL;

Dependencies

[top of page]

OKL.OKL_TRX_CONTRACTS_ALL does not reference any database object

OKL.OKL_TRX_CONTRACTS_ALL is referenced by following:

APPS: OKL_TRX_CONTRACTS; OKL_TRX_CONTRACTS_ALL