APPS.BOMPKMUD dependencies on MTL_SYSTEM_ITEMS_VL

Line 1320: p_item_id IN mtl_system_items_vl.inventory_item_id%TYPE,

1316: --
1317: -- EXAMPLE
1318: --
1319: FUNCTION Get_Item_Name(
1320: p_item_id IN mtl_system_items_vl.inventory_item_id%TYPE,
1321: p_org_id IN mtl_system_items_vl.organization_id%TYPE)
1322: RETURN mtl_system_items_vl.concatenated_segments%TYPE
1323: IS
1324:

Line 1321: p_org_id IN mtl_system_items_vl.organization_id%TYPE)

1317: -- EXAMPLE
1318: --
1319: FUNCTION Get_Item_Name(
1320: p_item_id IN mtl_system_items_vl.inventory_item_id%TYPE,
1321: p_org_id IN mtl_system_items_vl.organization_id%TYPE)
1322: RETURN mtl_system_items_vl.concatenated_segments%TYPE
1323: IS
1324:
1325: CURSOR c_item_name IS

Line 1322: RETURN mtl_system_items_vl.concatenated_segments%TYPE

1318: --
1319: FUNCTION Get_Item_Name(
1320: p_item_id IN mtl_system_items_vl.inventory_item_id%TYPE,
1321: p_org_id IN mtl_system_items_vl.organization_id%TYPE)
1322: RETURN mtl_system_items_vl.concatenated_segments%TYPE
1323: IS
1324:
1325: CURSOR c_item_name IS
1326: SELECT msi.concatenated_segments

Line 1327: FROM mtl_system_items_vl msi

1323: IS
1324:
1325: CURSOR c_item_name IS
1326: SELECT msi.concatenated_segments
1327: FROM mtl_system_items_vl msi
1328: WHERE msi.inventory_item_id = p_item_id
1329: AND msi.organization_id = p_org_id;
1330:
1331: l_item_name mtl_system_items_vl.concatenated_segments%TYPE;

Line 1331: l_item_name mtl_system_items_vl.concatenated_segments%TYPE;

1327: FROM mtl_system_items_vl msi
1328: WHERE msi.inventory_item_id = p_item_id
1329: AND msi.organization_id = p_org_id;
1330:
1331: l_item_name mtl_system_items_vl.concatenated_segments%TYPE;
1332:
1333: BEGIN
1334: IF (p_item_id IS NOT NULL) THEN
1335: OPEN c_item_name;