VIEW: APPS.GMF_XLA_BATCH_RSRC_V

Source

View Text - Preformatted

SELECT bh.batch_id, bh.batch_no, bh.batch_status, bsr.batchstep_resource_id, rm.resources, rm.resource_desc, rm.resource_class, rb.recipe_id, rb.recipe_no, rb.recipe_version, bh.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 , cr_rsrc_mst rm, gme_batch_step_resources bsr 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 AND bh.batch_id = bsr.batch_id AND bh.organization_id = bsr.organization_id AND bsr.resources = rm.resources

View Text - HTML Formatted

SELECT BH.BATCH_ID
, BH.BATCH_NO
, BH.BATCH_STATUS
, BSR.BATCHSTEP_RESOURCE_ID
, RM.RESOURCES
, RM.RESOURCE_DESC
, RM.RESOURCE_CLASS
, RB.RECIPE_ID
, RB.RECIPE_NO
, RB.RECIPE_VERSION
, BH.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
, CR_RSRC_MST RM
, GME_BATCH_STEP_RESOURCES BSR
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
AND BH.BATCH_ID = BSR.BATCH_ID
AND BH.ORGANIZATION_ID = BSR.ORGANIZATION_ID
AND BSR.RESOURCES = RM.RESOURCES