APPS.GMDFMVAL_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 155: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE := 0;

151: xreturn_code OUT NOCOPY NUMBER) IS
152:
153: /* Local variables. */
154: /* ================ */
155: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE := 0;
156: l_item_um mtl_system_items_kfv.primary_uom_code%TYPE := NULL;
157: l_enabled_flag mtl_system_items_kfv.enabled_flag%TYPE := 0;
158:
159: CURSOR get_id IS

Line 156: l_item_um mtl_system_items_kfv.primary_uom_code%TYPE := NULL;

152:
153: /* Local variables. */
154: /* ================ */
155: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE := 0;
156: l_item_um mtl_system_items_kfv.primary_uom_code%TYPE := NULL;
157: l_enabled_flag mtl_system_items_kfv.enabled_flag%TYPE := 0;
158:
159: CURSOR get_id IS
160: SELECT inventory_item_id, primary_uom_code, enabled_flag

Line 157: l_enabled_flag mtl_system_items_kfv.enabled_flag%TYPE := 0;

153: /* Local variables. */
154: /* ================ */
155: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE := 0;
156: l_item_um mtl_system_items_kfv.primary_uom_code%TYPE := NULL;
157: l_enabled_flag mtl_system_items_kfv.enabled_flag%TYPE := 0;
158:
159: CURSOR get_id IS
160: SELECT inventory_item_id, primary_uom_code, enabled_flag
161: FROM mtl_system_items_kfv

Line 161: FROM mtl_system_items_kfv

157: l_enabled_flag mtl_system_items_kfv.enabled_flag%TYPE := 0;
158:
159: CURSOR get_id IS
160: SELECT inventory_item_id, primary_uom_code, enabled_flag
161: FROM mtl_system_items_kfv
162: WHERE concatenated_segments = pitem_no
163: AND organization_id = porganization_id;
164:
165: CURSOR get_it_id IS

Line 277: FROM mtl_system_items_kfv

273: AND line_type = 1;
274:
275: CURSOR get_uom IS
276: SELECT primary_uom_code
277: FROM mtl_system_items_kfv
278: WHERE inventory_item_id = l_item_id;
279:
280: /* ================================================ */
281: BEGIN