[Home] [Help]
View: GMF_XLA_BATCH_HDR_V
Product: | GMF - Process Manufacturing Financials |
Description: | SLA batch header view |
Implementation/DBA Data: |
APPS.GMF_XLA_BATCH_HDR_V
|
View Text
SELECT BH.BATCH_ID
, BH.BATCH_NO
, BH.BATCH_STATUS
, RB.RECIPE_ID
, RB.RECIPE_NO
, RB.RECIPE_VERSION
, GRB.ROUTING_ID
, GRB.ROUTING_NO
, GRB.ROUTING_VERS
, GRB.ROUTING_CLASS
, FFM.FORMULA_ID
, FFM.FORMULA_NO
, FFM.FORMULA_VERS
FROM GME_BATCH_HEADER BH
, GMD_RECIPE_VALIDITY_RULES VR
, GMD_RECIPES_B RB
, GMD_ROUTINGS_B GRB
, FM_FORM_MST_B FFM
WHERE 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
Name |
BATCH_ID |
BATCH_NO |
BATCH_STATUS |
RECIPE_ID |
RECIPE_NO |
RECIPE_VERSION |
ROUTING_ID |
ROUTING_NO |
ROUTING_VERS |
ROUTING_CLASS |
FORMULA_ID |
FORMULA_NO |
FORMULA_VERS |