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

VIEW: APPS.ISC_EDW_BOOKINGS_F_FCV

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
BOOKINGS_PK VARCHAR2 (81)
Unique Identifier
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)
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)
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)
DATE_BOOKED_FK VARCHAR2 (76)
Foreign key to the Time dimension (Date Booked)
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)
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)
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_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)
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)
SET_OF_BOOKS_FK VARCHAR2 (71)
Foreign key to the Set of Books dimension (GL Set of Book)
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)
UOM_UOM_FK VARCHAR2 (4000)
Foreign key to the UoM dimension
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
TOTAL_NET_ORDER_VALUE VARCHAR2 (0)
Total net value for the entire order (non additive across lines of the same order)
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
AGREEMENT_ID VARCHAR2 (40)
Id of the Agreement to which this order relates to
BOOKED_DATE DATE

Date Booked
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
CUST_PO_NUMBER VARCHAR2 (50)
Customer's Purchase Order Number
DATE_FULFILLED DATE

Date Fulfilled
DATE_LATEST_PICK DATE

Date Latest Pick
DATE_LATEST_SHIP DATE

Date Latest Ship
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
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
ORDERED_DATE DATE

Date Ordered
ORDER_NUMBER NUMBER

Sales Order Number in the source system
PRICE_LIST_ID VARCHAR2 (40)
Id of the Price List from which the List Price was issued
PROMISED_DATE DATE

Date Promised
REQUESTED_DATE DATE

Date Requested
SCHEDULED_DATE DATE

Date Scheduled
SEQ_ID NUMBER

Sequence Id used by the collection program
SHIPPABLE_FLAG VARCHAR2 (1)
Flag indicating if the line is shippable or not.
TRANSACTABLE_FLAG CHAR (6)
Reserved for future use
VIEW_TYPE NUMBER

Column used by the collection program
USER_ATTRIBUTE1 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE2 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE3 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE4 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE5 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE6 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE7 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE8 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE9 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE10 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE11 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE12 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE13 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE14 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE15 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE16 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE17 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE18 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE19 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE20 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE21 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE22 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE23 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE24 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE25 VARCHAR2 (0)
Uder defined attribute
USER_FK1 CHAR (6)
System generated foreign key to user defined dimension
USER_FK2 CHAR (6)
System generated foreign key to user defined dimension
USER_FK3 CHAR (6)
System generated foreign key to user defined dimension
USER_FK4 CHAR (6)
System generated foreign key to user defined dimension
USER_FK5 CHAR (6)
System generated 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 BOOKINGS_PK
,      AGREEMENT_TYPE_FK
,      BILL_TO_CUST_FK
,      BILL_TO_LOC_FK
,      CAMPAIGN_ACTL_FK
,      CAMPAIGN_INIT_FK
,      CAMPAIGN_STATUS_ACTL_FK
,      CAMPAIGN_STATUS_INIT_FK
,      CANCEL_REASON_FK
,      CURRENCY_TRN_FK
,      CUSTOMER_FK
,      DATE_BOOKED_FK
,      DATE_PROMISED_FK
,      DATE_REQUESTED_FK
,      DATE_SCHEDULED_FK
,      DEMAND_CLASS_FK
,      EVENT_OFFER_ACTL_FK
,      EVENT_OFFER_INIT_FK
,      EVENT_OFFER_REG_FK
,      INSTANCE_FK
,      INV_ORG_FK
,      ITEM_ORG_FK
,      MARKET_SEGMENT_FK
,      MEDCHN_ACTL_FK
,      MEDCHN_INIT_FK
,      OFFER_HDR_FK
,      OFFER_LINE_FK
,      OPERATING_UNIT_FK
,      ORDER_CATEGORY_FK
,      ORDER_SOURCE_FK
,      ORDER_TYPE_FK
,      RETURN_REASON_FK
,      SALES_CHANNEL_FK
,      SALES_PERSON_FK
,      SET_OF_BOOKS_FK
,      SHIP_TO_CUST_FK
,      SHIP_TO_LOC_FK
,      SOURCE_LIST_FK
,      TARGET_SEGMENT_ACTL_FK
,      TARGET_SEGMENT_INIT_FK
,      TASK_FK
,      TOP_MODEL_FK
,      UOM_UOM_FK
,      QTY_CANCELLED
,      QTY_FULFILLED
,      QTY_INVOICED
,      QTY_ORDERED
,      QTY_RESERVED
,      QTY_RETURNED
,      QTY_SHIPPED
,      TOTAL_NET_ORDER_VALUE
,      UNIT_COST_G
,      UNIT_COST_T
,      UNIT_LIST_PRC_G
,      UNIT_LIST_PRC_T
,      UNIT_SELL_PRC_G
,      UNIT_SELL_PRC_T
,      AGREEMENT_ID
,      BOOKED_DATE
,      CONFIGURATION_ITEM_FLAG
,      CONVERSION_DATE
,      CONVERSION_RATE
,      CONVERSION_TYPE
,      CUST_PO_NUMBER
,      DATE_FULFILLED
,      DATE_LATEST_PICK
,      DATE_LATEST_SHIP
,      FULFILLMENT_FLAG
,      HEADER_ID
,      INCLUDED_ITEM_FLAG
,      INSTANCE
,      ITEM_TYPE_CODE
,      LAST_UPDATE_DATE
,      LINE_DETAIL_ID
,      LINE_ID
,      ORDERED_DATE
,      ORDER_NUMBER
,      PRICE_LIST_ID
,      PROMISED_DATE
,      REQUESTED_DATE
,      SCHEDULED_DATE
,      SEQ_ID
,      SHIPPABLE_FLAG
,      TRANSACTABLE_FLAG
,      VIEW_TYPE
,      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_BOOKINGS_F_FCV;

Dependencies

[top of page]

APPS.ISC_EDW_BOOKINGS_F_FCV references the following:

SchemaAPPS
PL/SQL PackageEDW_CURRENCY - show dependent code
PL/SQL PackageEDW_GEOGRAPHY_PKG - show dependent code
PL/SQL PackageEDW_ORGANIZATION_PKG - show dependent code
PL/SQL PackageEDW_UTIL - show dependent code
PL/SQL PackageGL_CURRENCY_API - show dependent code
ViewISCBV_BOOKINGS_FCV
APPS.ISC_EDW_BOOKINGS_F_FCV is referenced by following:

SchemaAPPS
Package BodyISC_EDW_BOOKINGS_F_C - show dependent code