VIEW: APPS.ISC_EDW_BACKLOGS_F_FCV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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