[Home] [Help] [Dependency Information]
Object Name: | XTR_IRS_ACTUALS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_IRS_ACTUALS_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 |
---|---|---|---|---|
UNIQUE_REF_NUMBER | NUMBER | |||
COMPANY_CODE | VARCHAR2 | (7) | ||
CURRENCY | VARCHAR2 | (15) | ||
PORTFOLIO_CODE | VARCHAR2 | (7) | ||
INC_IG | VARCHAR2 | (1) | ||
AMOUNT_UNIT | NUMBER | |||
FUND_INVEST | VARCHAR2 | (6) | ||
FROM_DATE | DATE | |||
TO_DATE | DATE | |||
COMPANY_NAME | VARCHAR2 | (30) | ||
PORT_NAME | VARCHAR2 | (30) | ||
FLOATING_LESS | VARCHAR2 | (10) | ||
PF_AMT | NUMBER | |||
PX_AMT | NUMBER | |||
PT_AMT | NUMBER | |||
PF_DAYS | NUMBER | |||
PX_DAYS | NUMBER | |||
PT_DAYS | NUMBER | |||
PFW_AMT | NUMBER | |||
PXW_AMT | NUMBER | |||
PTW_AMT | NUMBER | |||
SF_AMT | NUMBER | |||
SX_AMT | NUMBER | |||
ST_AMT | NUMBER | |||
STW_AMT | NUMBER | |||
ST_DAYS | NUMBER | |||
PFA_AMT | NUMBER | |||
PXA_AMT | NUMBER | |||
PTA_AMT | NUMBER | |||
SA_AMT | NUMBER | |||
PFA_DAYS | NUMBER | |||
PXA_DAYS | NUMBER | |||
PTA_DAYS | NUMBER | |||
SA_DAYS | NUMBER | |||
PF_COVER | NUMBER | |||
PX_COVER | NUMBER | |||
PT_COVER | NUMBER | |||
ACTUAL_FIXED | NUMBER | |||
S_COVER | NUMBER | |||
POLICY_MAX | NUMBER | |||
POLICY_MIN | NUMBER | |||
DAY_ADJUST | NUMBER | |||
VARIANCE_MIN | NUMBER | |||
MIN_WAMT | NUMBER | |||
VARIANCE_MAX | NUMBER | |||
MAX_WAMT | NUMBER | |||
MAX_AMT | NUMBER | |||
MIN_AMT | NUMBER | |||
CREATED_ON | DATE | |||
CREATED_BY | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT UNIQUE_REF_NUMBER
, COMPANY_CODE
, CURRENCY
, PORTFOLIO_CODE
, INC_IG
, AMOUNT_UNIT
, FUND_INVEST
, FROM_DATE
, TO_DATE
, COMPANY_NAME
, PORT_NAME
, FLOATING_LESS
, PF_AMT
, PX_AMT
, PT_AMT
, PF_DAYS
, PX_DAYS
, PT_DAYS
, PFW_AMT
, PXW_AMT
, PTW_AMT
, SF_AMT
, SX_AMT
, ST_AMT
, STW_AMT
, ST_DAYS
, PFA_AMT
, PXA_AMT
, PTA_AMT
, SA_AMT
, PFA_DAYS
, PXA_DAYS
, PTA_DAYS
, SA_DAYS
, PF_COVER
, PX_COVER
, PT_COVER
, ACTUAL_FIXED
, S_COVER
, POLICY_MAX
, POLICY_MIN
, DAY_ADJUST
, VARIANCE_MIN
, MIN_WAMT
, VARIANCE_MAX
, MAX_WAMT
, MAX_AMT
, MIN_AMT
, CREATED_ON
, CREATED_BY
FROM APPS.XTR_IRS_ACTUALS_V;
APPS.XTR_IRS_ACTUALS_V is not referenced by any database object
|
|
|