View: ISC_EDW_BACKLOGS_F_FCV

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

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