[Home] [Help] [Dependency Information]
Object Name: | ISC_DBI_SHORTFALL_SNAPSHOTS |
---|---|
Object Type: | TABLE |
Owner: | ISC |
FND Design Data: | ISC.ISC_DBI_SHORTFALL_SNAPSHOTS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | |
---|---|
PCT Free: | |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_DBI_SHORTFALL_SNAPSHOTS_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
START_DATE
PERIOD_TYPE_ID REASON_TYPE SNAPSHOT_ID |
ISC_DBI_SHORTFALL_SNAPSHOTS_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | ORGANIZATION_ID |
ISC_DBI_SHORTFALL_SNAPSHOTS_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
R_ITEM_ID
R_ORG_ID |
ISC_DBI_SHORTFALL_SNAPSHOTS_N4 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | R_SUPPLIER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SNAPSHOT_ID | NUMBER | |||
DMD_ITEM_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
PERIOD_TYPE_ID | NUMBER | |||
R_DEPARTMENT_ID | NUMBER | |||
R_ITEM_ID | NUMBER | |||
R_ORG_ID | NUMBER | |||
R_RESOURCE_ID | NUMBER | |||
R_SUPPLIER_ID | NUMBER | |||
R_SUPPLIER_SITE_ID | NUMBER | |||
START_DATE | DATE | |||
COST_SHORTFALL | NUMBER | |||
COST_SHORTFALL_G | NUMBER | |||
COST_TEMP | NUMBER | |||
COST_TEMP_G | NUMBER | |||
LATE_LINES_TEMP | NUMBER | |||
ORGANIZATION_TYPE | NUMBER | |||
REASON_TYPE | NUMBER | |||
REV_SHORTFALL | NUMBER | |||
REV_SHORTFALL_G | NUMBER | |||
REV_TEMP | NUMBER | |||
REV_TEMP_G | NUMBER | |||
TOTAL_LINES_TEMP | NUMBER | |||
UOM_CODE | VARCHAR2 | (3) | ||
COST_SHORTFALL_G1 | NUMBER | Potential Cost Shortfall amount in Secondary Global Currency | ||
COST_TEMP_G1 | NUMBER | Cost amount in Secondary Global Currency | ||
REV_SHORTFALL_G1 | NUMBER | Potential Revenue Shortfall amount in Secondary Global Currency | ||
REV_TEMP_G1 | NUMBER | Revenue amount in Secondary Global Currency |
Cut, paste (and edit) the following text to query this object:
SELECT SNAPSHOT_ID
, DMD_ITEM_ID
, ORGANIZATION_ID
, PERIOD_TYPE_ID
, R_DEPARTMENT_ID
, R_ITEM_ID
, R_ORG_ID
, R_RESOURCE_ID
, R_SUPPLIER_ID
, R_SUPPLIER_SITE_ID
, START_DATE
, COST_SHORTFALL
, COST_SHORTFALL_G
, COST_TEMP
, COST_TEMP_G
, LATE_LINES_TEMP
, ORGANIZATION_TYPE
, REASON_TYPE
, REV_SHORTFALL
, REV_SHORTFALL_G
, REV_TEMP
, REV_TEMP_G
, TOTAL_LINES_TEMP
, UOM_CODE
, COST_SHORTFALL_G1
, COST_TEMP_G1
, REV_SHORTFALL_G1
, REV_TEMP_G1
FROM ISC.ISC_DBI_SHORTFALL_SNAPSHOTS;
ISC.ISC_DBI_SHORTFALL_SNAPSHOTS does not reference any database object
ISC.ISC_DBI_SHORTFALL_SNAPSHOTS is referenced by following:
|
|
|