View: ISC_EDW_BOOKINGS_F_FCV

Product:	ISC - Supply Chain Intelligence
Description:	This is the collection view for the Bookings fact table
Implementation/DBA Data:	APPS.ISC_EDW_BOOKINGS_F_FCV

View Text

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
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM ISCBV_BOOKINGS_FCV

Columns