[Home] [Help] [Dependency Information]
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 |
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 |
---|---|---|---|---|
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 |
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;
|
|
|