DBA Data[Home] [Help]

APPS.GME_CREATE_BATCH_PVT dependencies on FM_ROUT_DTL

Line 2922: x_routingstep_id fm_rout_dtl.routingstep_id%TYPE) IS

2918: FROM gme_batch_steps
2919: WHERE batch_id = x_batch_id ;
2920:
2921: CURSOR calculate_mtq_cursor (x_batch_id gme_batch_header.batch_id%TYPE,
2922: x_routingstep_id fm_rout_dtl.routingstep_id%TYPE) IS
2923:
2924: -- Bug 8226667 - Changed select from inline calculation to using variables.
2925: /*
2926: SELECT

Line 2957: fm_rout_dtl frd,

2953: frd.step_qty
2954: FROM fm_form_mst ffm,
2955: fm_matl_dtl fmd,
2956: fm_rout_hdr frh,
2957: fm_rout_dtl frd,
2958: mtl_system_items iim,
2959: gme_batch_header gbh,
2960: gmd_recipe_validity_rules ffe
2961: WHERE gbh.batch_id = x_batch_id