VIEW: APPS.GMF_XLA_BATCH_DETAILS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)