643: NULL,
644: gmf_vib_id_s.nextval,
645: p.organization_id,
646: l_vib_profile_value
647: FROM gme_batch_step_resources m
648: WHERE batchstep_id = ds.dep_step_id;
649:
650: END LOOP;
651: END LOOP;
757: NULL,
758: gmf_vib_id_s.nextval,
759: p.organization_id,
760: l_vib_profile_value
761: FROM gme_material_details p, gme_batch_step_resources r
762: WHERE
763: p.batch_id = p_batch_id AND
764: r.batch_id = p_batch_id AND
765: p.line_type = 1 AND
881: NULL,
882: gmf_vib_id_s.nextval,
883: p.organization_id,
884: l_vib_profile_value
885: FROM gme_material_details p, gme_batch_step_resources r
886: WHERE
887: p.batch_id = p_batch_id AND
888: r.batch_id = p_batch_id AND
889: p.line_type = 1 AND
1683:
1684: ELSE
1685: SELECT m.usage_uom, 0, r.std_usage_um
1686: INTO l_doc_um, l_line_type, l_item_um
1687: FROM gme_batch_step_resources m, cr_rsrc_mst_b r
1688: WHERE
1689: m.batch_id = req.batch_id AND
1690: m.batchstep_resource_id = req.batchstep_resource_id AND
1691: m.resources = r.resources;