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

VIEW: APPS.ISCBV_EDW_BOOK_SUM1_BASE_FCV

Object Details
Object Name: ISCBV_EDW_BOOK_SUM1_BASE_FCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewISC.ISCBV_EDW_BOOK_SUM1_BASE_FCV
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This is the base view for the Bookings Summary 1 Fact


[View Source]

Columns
Name Datatype Length Mandatory Comments
SEQ_ID NUMBER

Sequence Id used by the collection program
BOOKINGS_PK VARCHAR2 (71)
Unique Identifier
BILL_TO_CUST_FK VARCHAR2 (85)
Foreign key to the Trading Partner dimension (Bill-to Site)
CURRENCY_BASE_FK VARCHAR2 (15)
Foreign key to the Currency dimension (Base Currency)
DATE_BOOKED_FK VARCHAR2 (76)
Foreign key to the Time dimension (Date Booked)
INSTANCE_FK VARCHAR2 (30)
Foreign key to the Instance dimension
OPERATING_UNIT_FK VARCHAR2 (4000)
Foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
SET_OF_BOOKS_FK VARCHAR2 (71)
Foreign key to the Set of Books dimension (GL Set of Book)
BOOKED_AMT_B NUMBER

Total amount of bookings in Base Currency
BOOKED_AMT_G NUMBER

Total amount of bookings in Warehouse Currency
BOOKED_LIST_AMT_B NUMBER

Total amount of bookings in list price in Base Currency
BOOKED_LIST_AMT_G NUMBER

Total amount of bookings in list price in Warehouse Currency
FULFILLED_AMT_B NUMBER

Total amount fulfilled in Base Currency
FULFILLED_AMT_G NUMBER

Total amount fulfilled in Warehouse Currency
INVOICED_AMT_B NUMBER

Total amount invoiced in Base Currency
INVOICED_AMT_G NUMBER

Total amount invoiced in Warehouse Currency
SHIPPED_AMT_B NUMBER

Total amount shipped in Base Currency
SHIPPED_AMT_G NUMBER

Total amount shipped in Warehouse Currency
DATE_BOOKED DATE

Date Booked
DATE_LATEST_FULFILLED DATE

Date latest fulfilled
DATE_LATEST_SHIP DATE

Date latest shipped
DATE_ORDERED DATE

Date Ordered
HEADER_ID NUMBER
Yes Sales Order Header Identifier in the source system
INSTANCE VARCHAR2 (30)
Instance
ORDER_NUMBER NUMBER
Yes Sales Order Number in the source system
USER_ATTRIBUTE1 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE9 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE15 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE16 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE17 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE18 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE19 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE20 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE21 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE22 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE23 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE24 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE25 VARCHAR2 (0)
User defined attribute
USER_FK1 CHAR (6)
Foreign key to user defined dimension
USER_FK2 CHAR (6)
Foreign key to user defined dimension
USER_FK3 CHAR (6)
Foreign key to user defined dimension
USER_FK4 CHAR (6)
Foreign key to user defined dimension
USER_FK5 CHAR (6)
Foreign key to user defined dimension
USER_MEASURE1 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE5 NUMBER

User defined measure
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.ISCBV_EDW_BOOK_SUM1_BASE_FCV;

Dependencies

[top of page]

APPS.ISCBV_EDW_BOOK_SUM1_BASE_FCV references the following:

SchemaAPPS
PL/SQL PackageEDW_CURRENCY - show dependent code
SynonymEDW_LOCAL_INSTANCE
SynonymEDW_LOCAL_SYSTEM_PARAMETERS
PL/SQL PackageEDW_ORGANIZATION_PKG - show dependent code
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
PL/SQL PackageGL_CURRENCY_API - show dependent code
ViewGL_SETS_OF_BOOKS
SynonymISC_TMP_BOOK_SUM1
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
APPS.ISCBV_EDW_BOOK_SUM1_BASE_FCV is referenced by following:

SchemaAPPS
ViewISCBV_EDW_BOOK_SUM1_FCV