DBA Data[Home] [Help]

APPS.GMD_QC_LABELS_UTIL dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 270: FROM mtl_system_items_b_kfv

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;
273:
274: l_sample_orgn_code mtl_parameters.organization_code%TYPE;

Line 279: l_item_code mtl_system_items_b_kfv.concatenated_segments%TYPE; --BUG# 4612611

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.
283: