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]

VIEW: APPS.ISC_EDW_BOOK_SUM1_F_FCV

Object Details

Object Name:	ISC_EDW_BOOK_SUM1_F_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ISC.ISC_EDW_BOOK_SUM1_F_FCV
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.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
SEQ_ID	NUMBER
BOOKINGS_PK	VARCHAR2	(71)
BILL_TO_CUST_FK	VARCHAR2	(85)
CURRENCY_BASE_FK	VARCHAR2	(15)
DATE_BOOKED_FK	VARCHAR2	(76)
INSTANCE_FK	VARCHAR2	(30)
OPERATING_UNIT_FK	VARCHAR2	(4000)
SET_OF_BOOKS_FK	VARCHAR2	(71)
BOOKED_AMT_B	NUMBER
BOOKED_AMT_G	NUMBER
BOOKED_LIST_AMT_B	NUMBER
BOOKED_LIST_AMT_G	NUMBER
FULFILLED_AMT_B	NUMBER
FULFILLED_AMT_G	NUMBER
INVOICED_AMT_B	NUMBER
INVOICED_AMT_G	NUMBER
SHIPPED_AMT_B	NUMBER
SHIPPED_AMT_G	NUMBER
DATE_BOOKED	DATE
DATE_LATEST_FULFILLED	DATE
DATE_LATEST_SHIP	DATE
DATE_ORDERED	DATE
HEADER_ID	NUMBER		Yes
INSTANCE	VARCHAR2	(30)
ORDER_NUMBER	NUMBER		Yes
USER_ATTRIBUTE1	VARCHAR2	(0)
USER_ATTRIBUTE2	VARCHAR2	(0)
USER_ATTRIBUTE3	VARCHAR2	(0)
USER_ATTRIBUTE4	VARCHAR2	(0)
USER_ATTRIBUTE5	VARCHAR2	(0)
USER_ATTRIBUTE6	VARCHAR2	(0)
USER_ATTRIBUTE7	VARCHAR2	(0)
USER_ATTRIBUTE8	VARCHAR2	(0)
USER_ATTRIBUTE9	VARCHAR2	(0)
USER_ATTRIBUTE10	VARCHAR2	(0)
USER_ATTRIBUTE11	VARCHAR2	(0)
USER_ATTRIBUTE12	VARCHAR2	(0)
USER_ATTRIBUTE13	VARCHAR2	(0)
USER_ATTRIBUTE14	VARCHAR2	(0)
USER_ATTRIBUTE15	VARCHAR2	(0)
USER_ATTRIBUTE16	VARCHAR2	(0)
USER_ATTRIBUTE17	VARCHAR2	(0)
USER_ATTRIBUTE18	VARCHAR2	(0)
USER_ATTRIBUTE19	VARCHAR2	(0)
USER_ATTRIBUTE20	VARCHAR2	(0)
USER_ATTRIBUTE21	VARCHAR2	(0)
USER_ATTRIBUTE22	VARCHAR2	(0)
USER_ATTRIBUTE23	VARCHAR2	(0)
USER_ATTRIBUTE24	VARCHAR2	(0)
USER_ATTRIBUTE25	VARCHAR2	(0)
USER_FK1	CHAR	(6)
USER_FK2	CHAR	(6)
USER_FK3	CHAR	(6)
USER_FK4	CHAR	(6)
USER_FK5	CHAR	(6)
USER_MEASURE1	NUMBER
USER_MEASURE2	NUMBER
USER_MEASURE3	NUMBER
USER_MEASURE4	NUMBER
USER_MEASURE5	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SEQ_ID
,      BOOKINGS_PK
,      BILL_TO_CUST_FK
,      CURRENCY_BASE_FK
,      DATE_BOOKED_FK
,      INSTANCE_FK
,      OPERATING_UNIT_FK
,      SET_OF_BOOKS_FK
,      BOOKED_AMT_B
,      BOOKED_AMT_G
,      BOOKED_LIST_AMT_B
,      BOOKED_LIST_AMT_G
,      FULFILLED_AMT_B
,      FULFILLED_AMT_G
,      INVOICED_AMT_B
,      INVOICED_AMT_G
,      SHIPPED_AMT_B
,      SHIPPED_AMT_G
,      DATE_BOOKED
,      DATE_LATEST_FULFILLED
,      DATE_LATEST_SHIP
,      DATE_ORDERED
,      HEADER_ID
,      INSTANCE
,      ORDER_NUMBER
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE16
,      USER_ATTRIBUTE17
,      USER_ATTRIBUTE18
,      USER_ATTRIBUTE19
,      USER_ATTRIBUTE20
,      USER_ATTRIBUTE21
,      USER_ATTRIBUTE22
,      USER_ATTRIBUTE23
,      USER_ATTRIBUTE24
,      USER_ATTRIBUTE25
,      USER_FK1
,      USER_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
FROM APPS.ISC_EDW_BOOK_SUM1_F_FCV;