[Home] [Help]
[Dependency Information]
| Object Name: | XTR_JEA_DUPLICATE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | XTR.XTR_JEA_DUPLICATE_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 |
|---|---|---|---|---|
| COMPANY_CODE | VARCHAR2 | (7) | Yes | |
| DEAL_TYPE | VARCHAR2 | (7) | Yes | |
| DEAL_SUBTYPE | VARCHAR2 | (7) | Yes | |
| AMOUNT_TYPE | VARCHAR2 | (7) | Yes | |
| DATE_TYPE | VARCHAR2 | (7) | Yes | |
| CREDIT_OR_DEBIT | VARCHAR2 | (2) | Yes | |
| GET_GL_FROM_DEAL | VARCHAR2 | (1) | Yes | |
| CREATED_BY | VARCHAR2 | (30) | Yes | |
| CREATED_ON | DATE | Yes | ||
| UPDATED_BY | VARCHAR2 | (30) | ||
| UPDATED_ON | DATE | |||
| ACTION_CODE | VARCHAR2 | (7) | ||
| CODE_COMBINATION_ID | NUMBER | (15) | ||
| COMMENTS | VARCHAR2 | (255) | ||
| PRODUCT_TYPE | VARCHAR2 | (10) | ||
| PORTFOLIO_CODE | VARCHAR2 | (7) | ||
| AUDIT_INDICATOR | VARCHAR2 | (1) | ||
| PARTY_GL | VARCHAR2 | (1) | ||
| GET_PRIN_CCID_FROM_DEAL | VARCHAR2 | (1) | Yes | |
| GET_INT_CCID_FROM_DEAL | VARCHAR2 | (1) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT COMPANY_CODE
, DEAL_TYPE
, DEAL_SUBTYPE
, AMOUNT_TYPE
, DATE_TYPE
, CREDIT_OR_DEBIT
, GET_GL_FROM_DEAL
, CREATED_BY
, CREATED_ON
, UPDATED_BY
, UPDATED_ON
, ACTION_CODE
, CODE_COMBINATION_ID
, COMMENTS
, PRODUCT_TYPE
, PORTFOLIO_CODE
, AUDIT_INDICATOR
, PARTY_GL
, GET_PRIN_CCID_FROM_DEAL
, GET_INT_CCID_FROM_DEAL
FROM APPS.XTR_JEA_DUPLICATE_V;
APPS
XTR_JEA_DUPLICATE
APPS.XTR_JEA_DUPLICATE_V is not referenced by any database object
|
|
|
|