DBA Data[Home] [Help]

APPS.INV_LABEL_PVT15 dependencies on GMD_ROUTINGS_B

Line 95: l_routing_no gmd_routings_b.routing_no%TYPE;

91: l_batch_no gme_batch_header.batch_no%TYPE;
92: l_formula_no fm_form_mst_b.formula_no%TYPE;
93: l_oprn_no gmd_operations.oprn_no%TYPE;
94: l_recipe_no gmd_recipes_b.recipe_no%TYPE;
95: l_routing_no gmd_routings_b.routing_no%TYPE;
96:
97: l_item_description mtl_system_items_vl.description%type;
98: l_sample_disposition varchar2(100);
99: l_date_drawn varchar2(100);

Line 162: gmd_routings_b routings , mtl_parameters para,

158:
159: from gmd_samples gsmp, mtl_lot_numbers mln,
160: fm_form_mst_b formulamst , gme_batch_header batchheader ,
161: gmd_operations operations , gmd_recipes_b recipes ,
162: gmd_routings_b routings , mtl_parameters para,
163: mtl_system_items_vl msi, mtl_parameters para2
164: where
165: gsmp.sample_id = p_transaction_id AND
166: gsmp.inventory_item_id = mln.inventory_item_id(+) and