FND Design Data [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