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_BACKLOGS_BASE_FCV

Object Details

Object Name:	ISCBV_BACKLOGS_BASE_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 Snapshot fact table

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SEQ_ID	NUMBER			Sequence id used by the collection program
BACKLOGS_PK	VARCHAR2	(768)		Unique identifier
BASE_UOM_FK	VARCHAR2	(4000)		Foreign key to the UoM dimension
BILL_TO_CUST_FK	VARCHAR2	(85)		Foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_LOCATION_FK	VARCHAR2	(4000)		Foreign key to the Geography dimension (Bill-to Location)
CUSTOMER_FK	VARCHAR2	(86)		Foreign key to the Trading Partner dimension (Customer)
DATE_BALANCE_FK	VARCHAR2	(76)		Foreign key to the Time dimension (Date of Snapshot)
DEMAND_CLASS_FK	VARCHAR2	(61)		Foreign key to the Demand Class dimension
GL_BOOK_FK	VARCHAR2	(71)		Foreign key to the Set of Books dimension (GL Set of Book)
INSTANCE_FK	VARCHAR2	(30)		Foreign key to the Instance dimension
INV_ORG_FK	VARCHAR2	(71)		Foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
ITEM_ORG_FK	VARCHAR2	(117)		Foreign key to the Organization Item dimension
OPERATING_UNIT_FK	VARCHAR2	(4000)		Foreign key to the Internal Organization dimension (Operating Unit)
ORDER_CATEGORY_FK	VARCHAR2	(49)		Foreign key to the Lookup dimension (Sales Order Category)
ORDER_SOURCE_FK	VARCHAR2	(257)		Foreign key to the Lookup dimension (Sales Order Source)
ORDER_TYPE_FK	VARCHAR2	(45)		Foreign key to the Lookup dimension (Sales Order Type)
SALES_CHANNEL_FK	VARCHAR2	(61)		Foreign key to the Sales Channel dimension
SALES_PERSON_FK	VARCHAR2	(126)		Foreign key to the Sales Person dimension (Salesperson)
SHIP_TO_CUST_FK	VARCHAR2	(85)		Foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_LOCATION_FK	VARCHAR2	(4000)		Foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
TASK_FK	VARCHAR2	(78)		Foreign key to the Project dimension (Project Task)
TOP_MODEL_ITEM_FK	VARCHAR2	(117)		Foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material
TRX_CURRENCY_FK	VARCHAR2	(15)		Foreign key to the Currency dimension (Transaction Currency)
INSTANCE	VARCHAR2	(30)		Source instance
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
BILL_BKLG_MRG_T	NUMBER			Billing Backlog Gross Margin in Transaction Currency
SHIP_BKLG_MRG_T	NUMBER			Shipping Backlog Gross Margin in Transaction Currency
DLQT_BKLG_MRG_T	NUMBER			Delinquent Backlog Gross Margin in Transaction Currency
BILL_BKLG_REV_T	NUMBER			Billing Backlog Revenue in Transaction Currency
SHIP_BKLG_REV_T	NUMBER			Shipping Backlog Revenue in Transaction Currency
DLQT_BKLG_REV_T	NUMBER			Delinquent Backlog Revenue in Transaction Currency
BILL_BKLG_COST_T	NUMBER			Billing Backlog Cost in Transaction Currency
SHIP_BKLG_COST_T	NUMBER			Shipping Backlog Cost in Transaction Currency
DLQT_BKLG_COST_T	NUMBER			Delinquent Backlog Cost in Transaction Currency
BILL_BKLG_MRG_G	NUMBER			Billing Backlog Gross Margin in Warehouse Currency
SHIP_BKLG_MRG_G	NUMBER			Shipping Backlog Gross Margin in Warehouse Currency
DLQT_BKLG_MRG_G	NUMBER			Delinquent Backlog Gross Margin in Warehouse Currency
BILL_BKLG_REV_G	NUMBER			Billing Backlog Revenue in Warehouse Currency
SHIP_BKLG_REV_G	NUMBER			Shipping Backlog Revenue in Warehouse Currency
DLQT_BKLG_REV_G	NUMBER			Delinquent Backlog Revenue in Warehouse Currency
BILL_BKLG_COST_G	NUMBER			Billing Backlog Cost in Warehouse Currency
SHIP_BKLG_COST_G	NUMBER			Shipping Backlog Cost in Warehouse Currency
DLQT_BKLG_COST_G	NUMBER			Delinquent Backlog Cost in Warehouse Currency
QTY_BILL_BKLG_B	NUMBER			Billing Backlog Quantity
QTY_SHIP_BKLG_B	NUMBER			Shipping Backlog Quantity
QTY_DLQT_BKLG_B	NUMBER			Delinquent Backlog Quantity
QTY_UNBILL_SHIP_B	NUMBER			Unbilled Shipments Backlog Quantity
UNBILL_SHIP_REV_T	NUMBER			Unbilled Shipments Revenue in Transaction Currency
UNBILL_SHIP_REV_G	NUMBER			Unbilled Shipments Revenue in Warehouse Currency
UNBILL_SHIP_COST_T	NUMBER			Unbilled Shipments Cost in Transaction Currency
UNBILL_SHIP_COST_G	NUMBER			Unbilled Shipments Cost in Warehouse Currency
UNBILL_SHIP_MRG_T	NUMBER			Unbilled Shipments Gross Margin in Transaction Currency
UNBILL_SHIP_MRG_G	NUMBER			Unbilled Shipments Gross Margin in Warehouse Currency
USER_ATTRIBUTE1	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE2	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE3	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE4	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE5	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE6	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE7	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE8	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE9	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE10	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE11	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE12	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE13	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE14	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE15	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE16	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE17	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE18	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE19	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE20	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE21	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE22	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE23	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE24	VARCHAR2	(0)		User attribute
USER_ATTRIBUTE25	VARCHAR2	(0)		User attribute
USER_FK1	VARCHAR2	(0)		Foreign key to user defined dimension
USER_FK2	VARCHAR2	(0)		Foreign key to user defined dimension
USER_FK3	VARCHAR2	(0)		Foreign key to user defined dimension
USER_FK4	VARCHAR2	(0)		Foreign key to user defined dimension
USER_FK5	VARCHAR2	(0)		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
,      BACKLOGS_PK
,      BASE_UOM_FK
,      BILL_TO_CUST_FK
,      BILL_TO_LOCATION_FK
,      CUSTOMER_FK
,      DATE_BALANCE_FK
,      DEMAND_CLASS_FK
,      GL_BOOK_FK
,      INSTANCE_FK
,      INV_ORG_FK
,      ITEM_ORG_FK
,      OPERATING_UNIT_FK
,      ORDER_CATEGORY_FK
,      ORDER_SOURCE_FK
,      ORDER_TYPE_FK
,      SALES_CHANNEL_FK
,      SALES_PERSON_FK
,      SHIP_TO_CUST_FK
,      SHIP_TO_LOCATION_FK
,      TASK_FK
,      TOP_MODEL_ITEM_FK
,      TRX_CURRENCY_FK
,      INSTANCE
,      LAST_UPDATE_DATE
,      BILL_BKLG_MRG_T
,      SHIP_BKLG_MRG_T
,      DLQT_BKLG_MRG_T
,      BILL_BKLG_REV_T
,      SHIP_BKLG_REV_T
,      DLQT_BKLG_REV_T
,      BILL_BKLG_COST_T
,      SHIP_BKLG_COST_T
,      DLQT_BKLG_COST_T
,      BILL_BKLG_MRG_G
,      SHIP_BKLG_MRG_G
,      DLQT_BKLG_MRG_G
,      BILL_BKLG_REV_G
,      SHIP_BKLG_REV_G
,      DLQT_BKLG_REV_G
,      BILL_BKLG_COST_G
,      SHIP_BKLG_COST_G
,      DLQT_BKLG_COST_G
,      QTY_BILL_BKLG_B
,      QTY_SHIP_BKLG_B
,      QTY_DLQT_BKLG_B
,      QTY_UNBILL_SHIP_B
,      UNBILL_SHIP_REV_T
,      UNBILL_SHIP_REV_G
,      UNBILL_SHIP_COST_T
,      UNBILL_SHIP_COST_G
,      UNBILL_SHIP_MRG_T
,      UNBILL_SHIP_MRG_G
,      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_BACKLOGS_BASE_FCV;

Dependencies

[top of page]

APPS.ISCBV_BACKLOGS_BASE_FCV references the following:

APPS: EDW_CURRENCY - show dependent code; EDW_GEOGRAPHY_PKG - show dependent code; EDW_LOCAL_INSTANCE; EDW_LOCAL_SYSTEM_PARAMETERS; EDW_ORGANIZATION_PKG - show dependent code; EDW_UTIL - show dependent code; FINANCIALS_SYSTEM_PARAMS_ALL; GL_CURRENCY_API - show dependent code; GL_SETS_OF_BOOKS; HR_ORGANIZATION_INFORMATION; ISC_TMP_BACK; MTL_SYSTEM_ITEMS_B; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OE_ORDER_SOURCES; OE_TRANSACTION_TYPES_TL

APPS.ISCBV_BACKLOGS_BASE_FCV is referenced by following:

APPS: ISCBV_BACKLOGS_FCV