eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_QC_LABELS_UTIL dependencies on MTL_PARAMETERS

Line 186: mtl_parameters mp

182: po_lines_all polinesall ,
183: rcv_shipment_headers rcvshiphdr ,
184: rcv_shipment_lines rcvshiplines ,
185: hr_operating_units hrops ,
186: mtl_parameters mp
187: WHERE
188: gsmp.supplier_id = povend.vendor_id AND
189: gsmp.supplier_site_id = povendsites.vendor_site_id(+) AND
190: gsmp.po_header_id = pohdrall.po_header_id(+) AND

Line 262: CURSOR get_orgn_code (v_organization_id mtl_parameters.organization_id%TYPE) IS

258: AND LOOKUP_CODE = p_retain_as;
259:
260: --JD Added cursor to get orgn_code for display.
261:
262: CURSOR get_orgn_code (v_organization_id mtl_parameters.organization_id%TYPE) IS
263: SELECT organization_code
264: FROM mtl_parameters
265: WHERE organization_id = v_organization_id;
266:

Line 264: FROM mtl_parameters

260: --JD Added cursor to get orgn_code for display.
261:
262: CURSOR get_orgn_code (v_organization_id mtl_parameters.organization_id%TYPE) IS
263: SELECT organization_code
264: FROM mtl_parameters
265: WHERE organization_id = v_organization_id;
266:
267: --BUG# 4612611. Added the cursor
268: CURSOR c_get_item (p_organization_id mtl_parameters.organization_id%TYPE, p_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE) IS

Line 268: CURSOR c_get_item (p_organization_id mtl_parameters.organization_id%TYPE, p_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE) IS

264: FROM mtl_parameters
265: WHERE organization_id = v_organization_id;
266:
267: --BUG# 4612611. Added the cursor
268: CURSOR c_get_item (p_organization_id mtl_parameters.organization_id%TYPE, p_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE) IS
269: SELECT concatenated_segments
270: FROM mtl_system_items_b_kfv
271: WHERE organization_id = p_organization_id
272: AND inventory_item_id = p_inventory_item_id;

Line 274: l_sample_orgn_code mtl_parameters.organization_code%TYPE;

270: FROM mtl_system_items_b_kfv
271: WHERE organization_id = p_organization_id
272: AND inventory_item_id = p_inventory_item_id;
273:
274: l_sample_orgn_code mtl_parameters.organization_code%TYPE;
275: l_lab_orgn_code mtl_parameters.organization_code%TYPE;
276: l_stab_orgn_code mtl_parameters.organization_code%TYPE;
277: l_stab_retain_orgn_code mtl_parameters.organization_code%TYPE;
278: l_smpl_storage_orgn_code mtl_parameters.organization_code%TYPE; --BUG# 4612611

Line 275: l_lab_orgn_code mtl_parameters.organization_code%TYPE;

271: WHERE organization_id = p_organization_id
272: AND inventory_item_id = p_inventory_item_id;
273:
274: l_sample_orgn_code mtl_parameters.organization_code%TYPE;
275: l_lab_orgn_code mtl_parameters.organization_code%TYPE;
276: l_stab_orgn_code mtl_parameters.organization_code%TYPE;
277: l_stab_retain_orgn_code mtl_parameters.organization_code%TYPE;
278: l_smpl_storage_orgn_code mtl_parameters.organization_code%TYPE; --BUG# 4612611
279: l_item_code mtl_system_items_b_kfv.concatenated_segments%TYPE; --BUG# 4612611

Line 276: l_stab_orgn_code mtl_parameters.organization_code%TYPE;

272: AND inventory_item_id = p_inventory_item_id;
273:
274: l_sample_orgn_code mtl_parameters.organization_code%TYPE;
275: l_lab_orgn_code mtl_parameters.organization_code%TYPE;
276: l_stab_orgn_code mtl_parameters.organization_code%TYPE;
277: l_stab_retain_orgn_code mtl_parameters.organization_code%TYPE;
278: l_smpl_storage_orgn_code mtl_parameters.organization_code%TYPE; --BUG# 4612611
279: l_item_code mtl_system_items_b_kfv.concatenated_segments%TYPE; --BUG# 4612611
280:

Line 277: l_stab_retain_orgn_code mtl_parameters.organization_code%TYPE;

273:
274: l_sample_orgn_code mtl_parameters.organization_code%TYPE;
275: l_lab_orgn_code mtl_parameters.organization_code%TYPE;
276: l_stab_orgn_code mtl_parameters.organization_code%TYPE;
277: l_stab_retain_orgn_code mtl_parameters.organization_code%TYPE;
278: l_smpl_storage_orgn_code mtl_parameters.organization_code%TYPE; --BUG# 4612611
279: l_item_code mtl_system_items_b_kfv.concatenated_segments%TYPE; --BUG# 4612611
280:
281:

Line 278: l_smpl_storage_orgn_code mtl_parameters.organization_code%TYPE; --BUG# 4612611

274: l_sample_orgn_code mtl_parameters.organization_code%TYPE;
275: l_lab_orgn_code mtl_parameters.organization_code%TYPE;
276: l_stab_orgn_code mtl_parameters.organization_code%TYPE;
277: l_stab_retain_orgn_code mtl_parameters.organization_code%TYPE;
278: l_smpl_storage_orgn_code mtl_parameters.organization_code%TYPE; --BUG# 4612611
279: l_item_code mtl_system_items_b_kfv.concatenated_segments%TYPE; --BUG# 4612611
280:
281:
282: -- JD Added cursor to get location for display.