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_BOOKINGS_FCV

Object Details

Object Name:	ISCBV_BOOKINGS_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 Bookings fact

[View Source]

Columns

Name	Datatype	Length	Comments
SEQ_ID	NUMBER		Sequence Id used by the collection program
VIEW_TYPE	NUMBER		Type of the view; used by the collection program
AGREEMENT_ID	VARCHAR2	(40)	Id of the Agreement to which this order relates to
AGREEMENT_TYPE_FK	VARCHAR2	(52)	Foreign key to the Lookup dimension (Customer Agreement Type)
BILL_TO_CUST_FK	VARCHAR2	(85)	Foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_LOC_FK	VARCHAR2	(4000)	Foreign key to the Geography dimension (Bill-to Location)
BOOKED_DATE	DATE		Date Booked
BOOKINGS_PK	VARCHAR2	(81)	Unique Identifier
CAMPAIGN_ACTL_FK	CHAR	(6)	Foreign key to the Campaign dimension (Campaign Actual)
CAMPAIGN_INIT_FK	CHAR	(6)	Foreign key to the Campaign dimension (Campaign Attributed)
CAMPAIGN_STATUS_ACTL_FK	CHAR	(6)	Foreign key to the Campaign Status dimension (Campaign Status Actual)
CAMPAIGN_STATUS_INIT_FK	CHAR	(6)	Foreign key to the Campaign Status dimension (Campaign Status Attributed)
CANCEL_REASON_FK	VARCHAR2	(46)	Foreign key to the Lookup dimension (Cancel Reason)
CONFIGURATION_ITEM_FLAG	VARCHAR2	(1)	Flag indicating if the item is part of a configuration.
CONVERSION_DATE	DATE		Currency Conversion Date
CONVERSION_RATE	NUMBER		Currency Conversion Rate
CONVERSION_TYPE	VARCHAR2	(30)	Currency Conversion Type
CURRENCY_TRN_FK	VARCHAR2	(15)	Foreign key to the Currency dimension (Transaction Currency)
CUSTOMER_FK	VARCHAR2	(86)	Foreign key to the Trading Partner dimension (Customer)
CUST_PO_NUMBER	VARCHAR2	(50)	Customer's Purchase Order Number
DATE_BOOKED_FK	VARCHAR2	(76)	Foreign key to the Time dimension (Date Booked)
DATE_FULFILLED	DATE		Date Fulfilled
DATE_LATEST_PICK	DATE		Date Latest Pick
DATE_LATEST_SHIP	DATE		Date Latest Ship
DATE_PROMISED_FK	VARCHAR2	(76)	Foreign key to the Time dimension (Date Promised)
DATE_REQUESTED_FK	VARCHAR2	(76)	Foreign key to the Time dimension (Date Requested)
DATE_SCHEDULED_FK	VARCHAR2	(76)	Foreign key to the Time dimension (Date Scheduled)
DEMAND_CLASS_FK	VARCHAR2	(61)	Foreign key to the Demand Class dimension
EVENT_OFFER_ACTL_FK	CHAR	(6)	Foreign key to the Event dimension (Event Offer Actual)
EVENT_OFFER_INIT_FK	CHAR	(6)	Foreign key to the Event dimension (Event Offer Attributed)
EVENT_OFFER_REG_FK	CHAR	(6)	Foreign key to the Event dimension (Event Registration)
FULFILLMENT_FLAG	VARCHAR2	(1)	Flag indicating if the line has been fulfilled (typically fully shipped and invoiced for shippable items, fully invoiced for non-shippable items)
HEADER_ID	NUMBER		Sales Order Header Identifier in the source system
INCLUDED_ITEM_FLAG	VARCHAR2	(1)	Flag indicating if the line is invoiceable or not. This flag is set to "Y" if the sales order line is not Internal, an "INCLUDED" item, and the invoiceable flag for this item = "Y"
INSTANCE	VARCHAR2	(30)	Source instance
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 Item dimension (Organization Item)
ITEM_TYPE_CODE	VARCHAR2	(30)	Code for the item type : STANDARD, CONFIG, KIT, MODEL, CLASS, OPTION, INCLUDED, SERVICE
LAST_UPDATE_DATE	DATE		Standard Who column
LINE_DETAIL_ID	CHAR	(6)	Sales Order Line Details Identifier in the source system
LINE_ID	NUMBER		Sales Order Line Identifier in the source system
MARKET_SEGMENT_FK	CHAR	(6)	Foreign key to the Market Segment dimension
MEDCHN_ACTL_FK	CHAR	(6)	Foreign key to the Media Channel dimension (Media Channel Actual)
MEDCHN_INIT_FK	CHAR	(6)	Foreign key to the Media Channel dimension (Media Channel Attributed)
OFFER_HDR_FK	CHAR	(6)	Foreign key to the Offer dimension (Header level)
OFFER_LINE_FK	CHAR	(6)	Foreign key to the Offer dimension (Line level)
OPERATING_UNIT_FK	VARCHAR2	(4000)	Foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
ORDER_CATEGORY_FK	VARCHAR2	(49)	Foreign key to the Lookup dimension (Sales Order Category)
ORDER_NUMBER	NUMBER		Sales Order Number in the source system
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)
ORDERED_DATE	DATE		Date Ordered
PRICE_LIST_ID	VARCHAR2	(40)	Id of the Price List from which the List Price was issued
PROMISED_DATE	DATE		Date Promised
QTY_CANCELLED	NUMBER		Quantity Canceled
QTY_FULFILLED	NUMBER		Quantity Fulfilled
QTY_INVOICED	NUMBER		Quantity Invoiced
QTY_ORDERED	NUMBER		Quantity Ordered
QTY_RESERVED	NUMBER		Quantity Reserved
QTY_RETURNED	NUMBER		Quantity Returned
QTY_SHIPPED	NUMBER		Quantity Shipped
REQUESTED_DATE	DATE		Date Requested
RETURN_REASON_FK	VARCHAR2	(52)	Foreign key to the Lookup dimension (Return Reason)
SALES_CHANNEL_FK	VARCHAR2	(61)	Foreign key to the Sales Channel dimension
SALES_PERSON_FK	VARCHAR2	(126)	Foreign key to the Person dimension (Salesperson)
SCHEDULED_DATE	DATE		Date Scheduled
SET_OF_BOOKS_FK	VARCHAR2	(71)	Foreign key to the Set of Books dimension (GL Set of Book)
SHIPPABLE_FLAG	VARCHAR2	(1)	Flag indicating if the line is shippable or not.
SHIP_TO_CUST_FK	VARCHAR2	(85)	Foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_LOC_FK	VARCHAR2	(4000)	Foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
SOURCE_LIST_FK	CHAR	(6)	Foreign key to the Source List dimension
TARGET_SEGMENT_ACTL_FK	CHAR	(6)	Foreign key to the Target Segment dimension (Target Segment Actual)
TARGET_SEGMENT_INIT_FK	CHAR	(6)	Foreign key to the Target Segment dimension (Target Segment Attributed)
TASK_FK	VARCHAR2	(78)	Foreign key to the Project dimension (Project Task)
TOP_MODEL_FK	VARCHAR2	(117)	Foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material (BOM)
TOTAL_NET_ORDER_VALUE	VARCHAR2	(0)	Total net value for the entire order (non additive across lines of the same order)
TRANSACTABLE_FLAG	CHAR	(6)	Reserved for future use
UNIT_COST_G	NUMBER		Unit Cost in Warehouse currency
UNIT_COST_T	NUMBER		Unit Cost in Transaction currency
UNIT_LIST_PRC_G	NUMBER		Unit List Price in Warehouse currency
UNIT_LIST_PRC_T	NUMBER		Unit List Price in Transaction currency
UNIT_SELL_PRC_G	NUMBER		Unit Sell Price in Warehouse Currency
UNIT_SELL_PRC_T	NUMBER		Unit Sell Price in Transaction Currency
UOM_UOM_FK	VARCHAR2	(4000)	Foreign key to the UoM dimension
_DF:HDR:_EDW	CHAR	(30)	Tag for Header Attribute Flexfield
_DF:HGA:_EDW	CHAR	(36)	Tag for Header Gloabal Attribute Flexfield
_DF:LNS:_EDW	CHAR	(28)	Tag for Line Attribute Flexfield
_DF:LGA:_EDW	CHAR	(26)	Tag for Line Global Attribute Flexfield
_DF:LIA:_EDW	CHAR	(36)	Tag for Line Industry Attribute Flexfield
_DF:LRA:_EDW	CHAR	(34)	Tag for Line Return Attribute Flexfield
_DF:LTA:_EDW	CHAR	(31)	Tag for Line Trading Partner Attribute Flexfield
_DF:AGT:_EDW	CHAR	(27)	Tag for Agreement Type Attribute Flexfield

Query Text

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


SELECT SEQ_ID
,      VIEW_TYPE
,      AGREEMENT_ID
,      AGREEMENT_TYPE_FK
,      BILL_TO_CUST_FK
,      BILL_TO_LOC_FK
,      BOOKED_DATE
,      BOOKINGS_PK
,      CAMPAIGN_ACTL_FK
,      CAMPAIGN_INIT_FK
,      CAMPAIGN_STATUS_ACTL_FK
,      CAMPAIGN_STATUS_INIT_FK
,      CANCEL_REASON_FK
,      CONFIGURATION_ITEM_FLAG
,      CONVERSION_DATE
,      CONVERSION_RATE
,      CONVERSION_TYPE
,      CURRENCY_TRN_FK
,      CUSTOMER_FK
,      CUST_PO_NUMBER
,      DATE_BOOKED_FK
,      DATE_FULFILLED
,      DATE_LATEST_PICK
,      DATE_LATEST_SHIP
,      DATE_PROMISED_FK
,      DATE_REQUESTED_FK
,      DATE_SCHEDULED_FK
,      DEMAND_CLASS_FK
,      EVENT_OFFER_ACTL_FK
,      EVENT_OFFER_INIT_FK
,      EVENT_OFFER_REG_FK
,      FULFILLMENT_FLAG
,      HEADER_ID
,      INCLUDED_ITEM_FLAG
,      INSTANCE
,      INSTANCE_FK
,      INV_ORG_FK
,      ITEM_ORG_FK
,      ITEM_TYPE_CODE
,      LAST_UPDATE_DATE
,      LINE_DETAIL_ID
,      LINE_ID
,      MARKET_SEGMENT_FK
,      MEDCHN_ACTL_FK
,      MEDCHN_INIT_FK
,      OFFER_HDR_FK
,      OFFER_LINE_FK
,      OPERATING_UNIT_FK
,      ORDER_CATEGORY_FK
,      ORDER_NUMBER
,      ORDER_SOURCE_FK
,      ORDER_TYPE_FK
,      ORDERED_DATE
,      PRICE_LIST_ID
,      PROMISED_DATE
,      QTY_CANCELLED
,      QTY_FULFILLED
,      QTY_INVOICED
,      QTY_ORDERED
,      QTY_RESERVED
,      QTY_RETURNED
,      QTY_SHIPPED
,      REQUESTED_DATE
,      RETURN_REASON_FK
,      SALES_CHANNEL_FK
,      SALES_PERSON_FK
,      SCHEDULED_DATE
,      SET_OF_BOOKS_FK
,      SHIPPABLE_FLAG
,      SHIP_TO_CUST_FK
,      SHIP_TO_LOC_FK
,      SOURCE_LIST_FK
,      TARGET_SEGMENT_ACTL_FK
,      TARGET_SEGMENT_INIT_FK
,      TASK_FK
,      TOP_MODEL_FK
,      TOTAL_NET_ORDER_VALUE
,      TRANSACTABLE_FLAG
,      UNIT_COST_G
,      UNIT_COST_T
,      UNIT_LIST_PRC_G
,      UNIT_LIST_PRC_T
,      UNIT_SELL_PRC_G
,      UNIT_SELL_PRC_T
,      UOM_UOM_FK
,      _DF:HDR:_EDW
,      _DF:HGA:_EDW
,      _DF:LNS:_EDW
,      _DF:LGA:_EDW
,      _DF:LIA:_EDW
,      _DF:LRA:_EDW
,      _DF:LTA:_EDW
,      _DF:AGT:_EDW
FROM APPS.ISCBV_BOOKINGS_FCV;

Dependencies

[top of page]

APPS.ISCBV_BOOKINGS_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; ISCBV_BOOKINGS_BASE_FCV; ISC_TMP_PK; MTL_RESERVATIONS; MTL_SYSTEM_ITEMS_B; OE_AGREEMENTS_B; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OE_ORDER_LINES_HISTORY; OE_ORDER_SOURCES; OE_TRANSACTION_TYPES_TL

APPS.ISCBV_BOOKINGS_FCV is referenced by following:

APPS: ISC_EDW_BOOKINGS_F_FCV