eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: ISC.ISC_DBI_SHORTFALL_SNAPSHOTS

Object Details

Object Name:	ISC_DBI_SHORTFALL_SNAPSHOTS
Object Type:	TABLE
Owner:	ISC
FND Design Data:	ISC.ISC_DBI_SHORTFALL_SNAPSHOTS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:
PCT Free:
PCT Used:

Indexes

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

Columns

Name	Datatype	Length	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

Query Text

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;

Dependencies

[top of page]

ISC.ISC_DBI_SHORTFALL_SNAPSHOTS does not reference any database object

ISC.ISC_DBI_SHORTFALL_SNAPSHOTS is referenced by following:

APPS: ISC_DBI_PM_0004_MV; ISC_DBI_SHORTFALL_SNAPSHOTS