APPS.INV_LABEL_PVT15 dependencies on MTL_SYSTEM_ITEMS_VL

Line 69: l_item mtl_system_items_vl.concatenated_segments%TYPE;

65: l_revision mtl_material_transactions.revision%TYPE;
66: l_organization mtl_parameters.organization_code%TYPE;
67: l_organization_id NUMBER;
68:
69: l_item mtl_system_items_vl.concatenated_segments%TYPE;
70: l_item_id NUMBER;
71: l_locator_id NUMBER;
72:
73: l_sample_id gmd_samples.sample_id%TYPE;

Line 97: l_item_description mtl_system_items_vl.description%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);
100: l_sample_instance gmd_samples.sample_instance%type;
101: l_print_count NUMBER;

Line 163: mtl_system_items_vl msi, mtl_parameters para2

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
167: gsmp.organization_id = mln.organization_id (+)and