[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FII_TIME_DAY |
|---|---|
| Object Type: | TABLE |
| Owner: | FII |
| FND Design Data: |  FII.FII_TIME_DAY
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FII_TIME_DAY_U1 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
 REPORT_DATE
|
| FII_TIME_DAY_U2 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
REPORT_DATE_JULIAN
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REPORT_DATE | DATE | Yes | Primary Key | |
| REPORT_DATE_JULIAN | NUMBER | Yes | Primary Key in Julian Day | |
| START_DATE | DATE | Yes | Start Date | |
| END_DATE | DATE | Yes | End Date | |
| MONTH_ID | NUMBER | Yes | Foreign Key for Gregorian Month | |
| ENT_PERIOD_ID | NUMBER | Foreign Key for Enterprise Period | ||
| ENT_PERIOD_START_DATE | DATE | Start date of the Enterprise | ||
| ENT_QTR_ID | NUMBER | Foreign Key for Enterprise Quarter | ||
| ENT_QTR_START_DATE | DATE | Start date of the Enterprise Quarter | ||
| ENT_YEAR_ID | NUMBER | Foreign Key for Enterprise Year | ||
| ENT_YEAR_START_DATE | DATE | Start date of the Enterprise Year | ||
| WEEK_ID | NUMBER | Yes | Foreign Key for Week | |
| WEEK_START_DATE | DATE | Yes | Start date of the Week | |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| WEEK_END_DATE | DATE | End date of the Week | ||
| ENT_PERIOD_END_DATE | DATE | End date of the Enterprise Period | ||
| ENT_QTR_END_DATE | DATE | End date of the Enterprise Quarter | ||
| ENT_YEAR_END_DATE | DATE | End date of the Enterprise Year |
Cut, paste (and edit) the following text to query this object:
SELECT REPORT_DATE
, REPORT_DATE_JULIAN
, START_DATE
, END_DATE
, MONTH_ID
, ENT_PERIOD_ID
, ENT_PERIOD_START_DATE
, ENT_QTR_ID
, ENT_QTR_START_DATE
, ENT_YEAR_ID
, ENT_YEAR_START_DATE
, WEEK_ID
, WEEK_START_DATE
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, WEEK_END_DATE
, ENT_PERIOD_END_DATE
, ENT_QTR_END_DATE
, ENT_YEAR_END_DATE
FROM FII.FII_TIME_DAY;
FII.FII_TIME_DAY does not reference any database object
FII.FII_TIME_DAY is referenced by following:
APPS
ASO_BI_QLIN_L2_MV
ASO_BI_QOT_APRB_MV
ASO_BI_QOT_DISCB_MV
ASO_BI_QOT_L1_MV
ASO_BI_QOT_RULB_MV
ASO_BI_TOP_QOTB_MV
BIL_BI_CAL_MV
BIL_BI_OPDTL_MV
BIL_BI_OPLDC_G_MV
BIL_BI_OPLPC_G_MV
BIL_BI_OPTY_G_MV
BIL_BI_OPTY_PG_MV
BIL_BI_TOPOP_G_MV
BIL_OBI_OPTY_PG_MV
BIL_OBI_PIPE_G_MV
BIM_I_BGT_CAT_MV
BIM_I_BGT_LVL_MV
BIM_I_LD_GENSG_T_MV
BIM_I_LP_GENSG_T_MV
BIM_I_MKT_CPB_MV
BIM_I_OBJ_METR_MV
BIM_LD_CAMP_T_MV
BIM_MKT_KPI_INT_MV
BIM_SGMT_ACT_CH_MV
BIM_SGMT_ACT_MV
BIM_SGMT_ACT_SH_MV
BIM_SGMT_VAL_F_MV
BIV_ACT_SUM_MV
BIV_BAC_SUM_MV
BIV_CLO_SUM_MV
BIV_RES_SUM_MV
ENI_DBI_AR_BASE_MV
ENI_DBI_COGS_BASE_MV
ENI_DBI_CO_UNION_MV
ENI_DBI_INV_BASE_MV
FII_AP_HATY_XB_MV
FII_AP_HCAT_I_MV
FII_AP_HLIA_IB_MV
FII_AP_HLIA_I_MV
FII_AP_INV_PAYMENTS_MV
FII_AP_IVATY_B_MV
FII_AP_LIA_I_MV
FII_AP_PAID_XB_MV
FII_AP_PAYOL_XB_MV
FII_AP_PMT_SCHEDULES_MV
FII_AR_BILLING_ACT_BASE_MV
FII_AR_DISPUTES_BASE_MV
FII_AR_NET_REC_INTR_MV
FII_AR_RCT_AGING_INTR_MV
FII_AR_REV_SUM_MV
FII_FA_EXP_MV
FII_TIME_DAY
HRI_MDP_SUP_WRKFC_JX_MV
IBE_BI_CART_ORD_MV
IBE_BI_CAT_TIME_MV
IBE_BI_CUSTTIME_MV
IBE_BI_TOP_CART_MV
IBE_BI_TOP_CUST_MV
IBE_BI_TOP_ORD_MV
IBE_BI_TOP_PROD_MV
IBW_CMPANALYSIS_TIME_MV
IBW_KPI_METRICS_TIME_MV
IBW_PAGE_SA_TIME_MV
IBW_PRODUCT_TIME_MV
IBW_REFANALYSIS_TIME_MV
IBW_VISIT_CUST_TIME_MV
ISC_DBI_CFM_000_MV
ISC_DBI_CFM_002_MV
ISC_DBI_CFM_004_MV
ISC_DBI_CFM_005_MV
ISC_DBI_CFM_007_MV
ISC_DBI_CPM_000_MV
ISC_DBI_CPM_002_MV
ISC_DBI_FM_0000_MV
ISC_DBI_FM_0001_MV
ISC_DBI_SCR_000_MV
ISC_DBI_SCR_001_MV
ISC_DR_BKLG_01_MV
ISC_DR_CHARGES_01_MV
ISC_DR_COSTS_01_MV
ISC_DR_MTTR_01_MV
ISC_DR_SERVICE_CODE_MV
ISC_FS_003_MV
ISC_FS_005_MV
ISC_FS_009_MV
ISC_FS_011_MV
ISC_FS_013_MV
ISC_FS_014_MV
ISC_FS_015_MV
ISC_FS_016_MV
ISC_FS_017_MV
ISC_FS_018_MV
ISC_FS_019_MV
ISC_FS_020_MV
ISC_MAINT_001_MV
ISC_MAINT_003_MV
ISC_MAINT_004_MV
ISC_MAINT_005_MV
ISC_MAINT_006_MV
ISC_SAM_000_MV
ISC_SAM_001_MV
ISC_SAM_002_MV
ISC_SAM_004_MV
ISC_SAM_005_MV
ISC_SAM_006_MV
ISC_SAM_007_MV
ISC_TRN_000_MV
ISC_TRN_001_MV
ISC_TRN_002_MV
ISC_TRN_003_MV
ISC_TRN_004_MV
ISC_TRN_006_MV
ISC_WMS_000_MV
ISC_WMS_001_MV
OKI_SRM_003_MV
OKI_SRM_011_MV
OKI_SRM_012_MV
OKI_SRM_013_MV
OKI_SRM_014_MV
OKI_SRM_015_MV
OKI_SRM_016_MV
OKI_SRM_017_MV
OKI_SRM_021_MV
OKI_SRM_022_MV
OKI_SRM_023_MV
OKI_SRM_024_MV
OKI_SRM_025_MV
OKI_SRM_026_MV
OKI_SRM_027_MV
OKI_SRM_031_MV
OKI_SRM_032_MV
OKI_SRM_033_MV
OKI_SRM_034_MV
OKI_SRM_035_MV
OKI_SRM_036_MV
OKI_SRM_037_MV
OKI_TIME_ENT_YEAR_MV
OPI_COGS_001_MV
OPI_DBI_RES_UTL_MV
OPI_DBI_RES_VAR_MV
OPI_INV_CCA_SUM_MV
OPI_INV_ITD_ORG_MV
OPI_INV_VAL_SUM_MV
OPI_JOBS_001_MV
OPI_MFG_VAR_SUM_MV
OPI_MTL_VAR_SUM_MV
OPI_ONTIME_PROD_001_MV
OPI_PGM_CBN_MV
OPI_PGM_SUM_MV
OPI_PTP_SUM_F_MV
OPI_PTP_SUM_STG_MV
OPI_SCRAP_REASON_001_MV
OPI_SCRAP_SUM_MV
OPI_WMS_001_MV
OPI_WMS_002_MV
OPI_WMS_004_MV
OPI_WMS_006_MV
OPI_WMS_007_MV
OPI_WMS_008_MV
OPI_WMS_009_MV
PJI_TIME_DAY_MV
PJI_TIME_PA_RPT_STR_MV
POA_API_BS_J_MV
POA_IDL_BS_J_MV
POA_MID_BS_J_MV
POA_NEG_000_MV
POA_POD_BS_J_MV
POA_PQC_BS_J_MV
POA_REQ_001_MV
POA_REQ_002_MV
POA_RTX_BS_J_MV
|
|
|
|