[Home] [Help] [Dependency Information]
Object Name: | OKL_SLA_TRX_INFO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_SLA_TRX_INFO_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
CONTRACT_NUMBER | VARCHAR2 | (120) | Contract Number | |
PRODUCT_NAME | VARCHAR2 | (150) | Yes | Product Name of the Contract or Investor Agreement. |
CUSTOMER_NAME | VARCHAR2 | (360) | Yes | Name of the Customer |
CUSTOMER_ACCOUNT | VARCHAR2 | (30) | Yes | Customer Account Number |
CURRENCY_CODE | VARCHAR2 | (150) | Currency code | |
TRANSACTION_NUMBER | VARCHAR2 | (30) | Yes | Transaction Number. If user does not specify a value, it is generated through a sequence |
TRANSACTION_DATE | DATE | Yes | Transaction date | |
CANCELLATION_DATE | DATE | Date on which the transaction is canceled | ||
INVESTOR_AGREEMENT_TYPE | VARCHAR2 | (80) | Investor Agreement Type | |
TERMINATION_QUOTE_NUMBER | NUMBER | Termination Quote Number | ||
TERMINATION_QUOTE_TYPE | VARCHAR2 | (80) | Termination Quote Type Code | |
INVESTOR_AGREEMENT_NUMBER | VARCHAR2 | (120) | Investor Agreement Number |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, CONTRACT_NUMBER
, PRODUCT_NAME
, CUSTOMER_NAME
, CUSTOMER_ACCOUNT
, CURRENCY_CODE
, TRANSACTION_NUMBER
, TRANSACTION_DATE
, CANCELLATION_DATE
, INVESTOR_AGREEMENT_TYPE
, TERMINATION_QUOTE_NUMBER
, TERMINATION_QUOTE_TYPE
, INVESTOR_AGREEMENT_NUMBER
FROM APPS.OKL_SLA_TRX_INFO_V;
APPS.OKL_SLA_TRX_INFO_V is not referenced by any database object
|
|
|