[Home] [Help]
View: PMI_EDW_BTCH_DTL_F_IV
Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ACTUAL_CMPLT_DATE
, ACTUAL_ING_VALUE
, ACTUAL_START_DATE
, ACTUAL_YIELD_QTY
, ACTUAL_YIELD_VALUE
, BASE_CURRENCY
, BATCH_DETAIL_PK
, BATCH_DETAIL_PK_KEY
, BATCH_NO
, BATCH_PRODUCT_UOM
, BATCH_STATUS_FK_KEY
, COST_METHOD
, FORMULA_FK_KEY
, ITEM_FK_KEY
, NO_OF_SAMPLES_ADJUSTED
, NO_OF_SAMPLES_COMPLETED
, NO_OF_SAMPLES_PASSED
, NO_OF_SAMPLES_TAKEN
, OPM_ORG_FK_KEY
, PLAN_CMPLT_DATE
, PLAN_ING_VALUE
, PLAN_START_DATE
, PLAN_YIELD_QTY
, PLAN_YIELD_VALUE
, ROUTING_FK_KEY
, STD_QTY
, STD_TIME
, TIME_FK_KEY
, 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_FK1_KEY
, USER_FK2_KEY
, USER_FK3_KEY
, USER_FK4_KEY
, USER_FK5_KEY
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, ROWID ROW_ID
, USER_ATTRIBUTE1 OPERATION_CODE
FROM PMI_EDW_BTCH_DTL_F
Columns
Name |
ACTUAL_CMPLT_DATE |
ACTUAL_ING_VALUE |
ACTUAL_START_DATE |
ACTUAL_YIELD_QTY |
ACTUAL_YIELD_VALUE |
BASE_CURRENCY |
BATCH_DETAIL_PK |
BATCH_DETAIL_PK_KEY |
BATCH_NO |
BATCH_PRODUCT_UOM |
BATCH_STATUS_FK_KEY |
COST_METHOD |
FORMULA_FK_KEY |
ITEM_FK_KEY |
NO_OF_SAMPLES_ADJUSTED |
NO_OF_SAMPLES_COMPLETED |
NO_OF_SAMPLES_PASSED |
NO_OF_SAMPLES_TAKEN |
OPM_ORG_FK_KEY |
PLAN_CMPLT_DATE |
PLAN_ING_VALUE |
PLAN_START_DATE |
PLAN_YIELD_QTY |
PLAN_YIELD_VALUE |
ROUTING_FK_KEY |
STD_QTY |
STD_TIME |
TIME_FK_KEY |
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_FK1_KEY |
USER_FK2_KEY |
USER_FK3_KEY |
USER_FK4_KEY |
USER_FK5_KEY |
USER_MEASURE1 |
USER_MEASURE2 |
USER_MEASURE3 |
USER_MEASURE4 |
USER_MEASURE5 |
ROW_ID |
OPERATION_CODE |