[Home] [Help]
View: GMF_XLA_BATCH_DETAILS_V
View Text
SELECT BH.BATCH_ID
, BH.BATCH_NO
, VR.RECIPE_ID
, BH.FORMULA_ID
, BH.ROUTING_ID
, BATCH_STATUS
, MD.MATERIAL_DETAIL_ID
, MD.LINE_TYPE
, MD.CONTRIBUTE_YIELD_IND AS CONTRIBUTE_TO_YIELD
, MD.CONTRIBUTE_STEP_QTY_IND AS CONTRIBUTE_TO_STEP_QTY
, MD.SCALE_TYPE
, MD.RELEASE_TYPE AS CONSUMPTION_TYPE
, MD.PHANTOM_TYPE
FROM GME_BATCH_HEADER BH
, GME_MATERIAL_DETAILS MD
, GMD_RECIPE_VALIDITY_RULES VR
WHERE MD.BATCH_ID = BH.BATCH_ID
AND BH.RECIPE_VALIDITY_RULE_ID = VR.RECIPE_VALIDITY_RULE_ID (+)
Columns
| Name |
| BATCH_ID |
| BATCH_NO |
| RECIPE_ID |
| FORMULA_ID |
| ROUTING_ID |
| BATCH_STATUS |
| MATERIAL_DETAIL_ID |
| LINE_TYPE |
| CONTRIBUTE_TO_YIELD |
| CONTRIBUTE_TO_STEP_QTY |
| SCALE_TYPE |
| CONSUMPTION_TYPE |
| PHANTOM_TYPE |
APPS.GMF_XLA_BATCH_DETAILS_V