[Home] [Help]
View: ISC_RISK_SHIP_DLQT_S
View Text
SELECT OPERATING_UNIT_FK_KEY OPER_UNIT_FK_KEY
, CUSTOMER_FK_KEY CUSTOMER_FK_KEY
, ORDER_NUMBER ORDER_NUMBER
, CUSTOMER_NAME CUSTOMER_NAME
, DATE_BOOKED BOOKED_DATE
, NVL(SHIP_BKLG_LINE_COUNT
, 0) SHIP_BKLG_LINE_COUNT
, NVL(SHIP_BKLG_AMT_G
, 0) SHIP_BKLG_AMT_G
, NVL(DAYS_OPEN
, 0) DAYS_OPEN
, NVL(DLQT_BKLG_LINE_COUNT
, 0) DLQT_BKLG_LINE_COUNT
, NVL(DLQT_BKLG_AMT_G
, 0) DLQT_BKLG_AMT_G
, NVL(MAX_DAYS_LATE
, 0) MAX_DAYS_LATE
, HEADER_ID HEADER_ID
FROM ISC_EDW_BACKLOG_SUM1_F
Columns
Name |
OPER_UNIT_FK_KEY |
CUSTOMER_FK_KEY |
ORDER_NUMBER |
CUSTOMER_NAME |
BOOKED_DATE |
SHIP_BKLG_LINE_COUNT |
SHIP_BKLG_AMT_G |
DAYS_OPEN |
DLQT_BKLG_LINE_COUNT |
DLQT_BKLG_AMT_G |
MAX_DAYS_LATE |
HEADER_ID |