View: GMF_XLA_BATCH_DETAILS_V

Product:	GMF - Process Manufacturing Financials
Description:	View for SLA ADR sources from Batch Details
Implementation/DBA Data:	APPS.GMF_XLA_BATCH_DETAILS_V

View Text

SELECT BH.BATCH_ID
, BH.BATCH_NO
, BATCH_STATUS
, VR.RECIPE_ID
, RB.RECIPE_NO
, RB.RECIPE_VERSION
, BH.FORMULA_ID
, FFM.FORMULA_NO
, FFM.FORMULA_VERS
, BH.ROUTING_ID
, GRB.ROUTING_NO
, GRB.ROUTING_VERS
, GRB.ROUTING_CLASS
, 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
, GMD_RECIPES_B RB
, GMD_ROUTINGS_B GRB
, FM_FORM_MST_B FFM
WHERE MD.BATCH_ID = BH.BATCH_ID
AND BH.RECIPE_VALIDITY_RULE_ID = VR.RECIPE_VALIDITY_RULE_ID (+)
AND VR.RECIPE_ID = RB.RECIPE_ID
AND BH.ROUTING_ID = GRB.ROUTING_ID(+)
AND BH.FORMULA_ID = FFM.FORMULA_ID(+)

Columns