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.ISCBV_EDW_BACKLOG_SUM1_B_FCV

Object Details

Object Name:	ISCBV_EDW_BACKLOG_SUM1_B_FCV
Object Type:	VIEW
Owner:	APPS
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 Backlog Summary 1 Fact

[View Source]

Columns

Name	Datatype	Length	Comments
BACKLOG_SUM1_PK	VARCHAR2	(71)	Unique identifier
CUSTOMER_ID	VARCHAR2	(40)	Foreign key to the customer level of Trading Partner dimension
FUNCTIONAL_CURRENCY	VARCHAR2	(15)	Foreign key to the Currency dimension
INSTANCE_CODE	VARCHAR2	(30)	Code of the source instance
OPERATING_UNIT_ID	VARCHAR2	(40)	Foreign key to the operating unit level of Organization dimension
SET_OF_BOOKS_ID	VARCHAR2	(40)	Foreign key to the Set of Books dimension
DATE_BOOKED	DATE		Date of the transaction when it has been booked
DATE_OF_SNAPSHOT	DATE		Date of the latest collection, "as of" date
DAYS_OPEN	NUMBER		Total number of days between the booked date and today (sysdate) for backlog orders
DLQT_BKLG_AMT_B	NUMBER		Total amount of delinquent backlog in base currency
DLQT_BKLG_AMT_G	NUMBER		Total amount of delinquent backlog in warehouse currency
DLQT_BKLG_LINE_COUNT	NUMBER		Total number of delinquent backlog lines
HEADER_ID	VARCHAR2	(40)	Unique identifier of the Header of an order
MAX_DAYS_LATE	NUMBER		Total number of days between the scheduled date and today (sysdate) for delinquent backlog orders
ORDER_NUMBER	VARCHAR2	(40)	Order Number
SHIP_BKLG_AMT_B	NUMBER		Total amount of shipping backlog in base currency
SHIP_BKLG_AMT_G	NUMBER		Total amount of shipping backlog in warehouse currency
SHIP_BKLG_LINE_COUNT	NUMBER		Total number of shipping backlog lines

Query Text

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


SELECT BACKLOG_SUM1_PK
,      CUSTOMER_ID
,      FUNCTIONAL_CURRENCY
,      INSTANCE_CODE
,      OPERATING_UNIT_ID
,      SET_OF_BOOKS_ID
,      DATE_BOOKED
,      DATE_OF_SNAPSHOT
,      DAYS_OPEN
,      DLQT_BKLG_AMT_B
,      DLQT_BKLG_AMT_G
,      DLQT_BKLG_LINE_COUNT
,      HEADER_ID
,      MAX_DAYS_LATE
,      ORDER_NUMBER
,      SHIP_BKLG_AMT_B
,      SHIP_BKLG_AMT_G
,      SHIP_BKLG_LINE_COUNT
FROM APPS.ISCBV_EDW_BACKLOG_SUM1_B_FCV;

Dependencies

[top of page]

APPS.ISCBV_EDW_BACKLOG_SUM1_B_FCV references the following:

APPS: EDW_CURRENCY - show dependent code; EDW_LOCAL_INSTANCE; EDW_LOCAL_SYSTEM_PARAMETERS; FINANCIALS_SYSTEM_PARAMS_ALL; GL_CURRENCY_API - show dependent code; GL_SETS_OF_BOOKS; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL

APPS.ISCBV_EDW_BACKLOG_SUM1_B_FCV is referenced by following:

APPS: ISCBV_EDW_BACKLOG_SUM1_FCV