FND Design Data [Home] [Help]

View: ISC_EDW_BACKLOGS_F_FCV

Product: ISC - Supply Chain Intelligence (Obsolete)
Description: This is the collection view for the Backlog Snapshot fact table
Implementation/DBA Data: Not implemented in this database
View Text

SELECT 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
, BILL_BKLG_COST_G
, BILL_BKLG_COST_T
, BILL_BKLG_MRG_G
, BILL_BKLG_MRG_T
, BILL_BKLG_REV_G
, BILL_BKLG_REV_T
, DLQT_BKLG_COST_G
, DLQT_BKLG_COST_T
, DLQT_BKLG_MRG_G
, DLQT_BKLG_MRG_T
, DLQT_BKLG_REV_G
, DLQT_BKLG_REV_T
, QTY_BILL_BKLG_B
, QTY_DLQT_BKLG_B
, QTY_SHIP_BKLG_B
, QTY_UNBILL_SHIP_B
, SHIP_BKLG_COST_G
, SHIP_BKLG_COST_T
, SHIP_BKLG_MRG_G
, SHIP_BKLG_MRG_T
, SHIP_BKLG_REV_G
, SHIP_BKLG_REV_T
, UNBILL_SHIP_COST_G
, UNBILL_SHIP_COST_T
, UNBILL_SHIP_MRG_G
, UNBILL_SHIP_MRG_T
, UNBILL_SHIP_REV_G
, UNBILL_SHIP_REV_T
, INSTANCE
, LAST_UPDATE_DATE
, SEQ_ID
, 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_BACKLOGS_FCV

Columns

Name
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
BILL_BKLG_COST_G
BILL_BKLG_COST_T
BILL_BKLG_MRG_G
BILL_BKLG_MRG_T
BILL_BKLG_REV_G
BILL_BKLG_REV_T
DLQT_BKLG_COST_G
DLQT_BKLG_COST_T
DLQT_BKLG_MRG_G
DLQT_BKLG_MRG_T
DLQT_BKLG_REV_G
DLQT_BKLG_REV_T
QTY_BILL_BKLG_B
QTY_DLQT_BKLG_B
QTY_SHIP_BKLG_B
QTY_UNBILL_SHIP_B
SHIP_BKLG_COST_G
SHIP_BKLG_COST_T
SHIP_BKLG_MRG_G
SHIP_BKLG_MRG_T
SHIP_BKLG_REV_G
SHIP_BKLG_REV_T
UNBILL_SHIP_COST_G
UNBILL_SHIP_COST_T
UNBILL_SHIP_MRG_G
UNBILL_SHIP_MRG_T
UNBILL_SHIP_REV_G
UNBILL_SHIP_REV_T
INSTANCE
LAST_UPDATE_DATE
SEQ_ID
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