DBA Data[Home] [Help]

APPS.GMDFMVAL_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

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

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

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

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

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

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

Line 163: FROM mtl_system_items_kfv

159:
160:
161: CURSOR get_id IS
162: SELECT inventory_item_id, primary_uom_code, enabled_flag
163: FROM mtl_system_items_kfv
164: WHERE concatenated_segments = pitem_no
165: AND organization_id = porganization_id;
166:
167: CURSOR get_it_id IS

Line 278: FROM mtl_system_items_kfv

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