APPS.INV_LABEL_PVT15 dependencies on MTL_PARAMETERS

Line 66: l_organization mtl_parameters.organization_code%TYPE;

62: l_label_err_msg VARCHAR2(1000);
63: l_is_epc_exist VARCHAR2(1) := 'N';
64:
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;

Line 74: l_orgn_code mtl_parameters.organization_code%TYPE;

70: l_item_id NUMBER;
71: l_locator_id NUMBER;
72:
73: l_sample_id gmd_samples.sample_id%TYPE;
74: l_orgn_code mtl_parameters.organization_code%TYPE;
75: l_sample_no gmd_samples.sample_no%TYPE;
76: l_sample_desc gmd_samples.sample_desc%TYPE;
77: l_sample_qty gmd_samples.sample_qty%TYPE;
78: l_sample_uom gmd_samples.sample_qty_uom%TYPE;

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

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