APPS.BOMPKMUD dependencies on MTL_SYSTEM_ITEMS_VL

Line 1325: p_item_id IN mtl_system_items_vl.inventory_item_id%TYPE,

1321: --
1322: -- EXAMPLE
1323: --
1324: FUNCTION Get_Item_Name(
1325: p_item_id IN mtl_system_items_vl.inventory_item_id%TYPE,
1326: p_org_id IN mtl_system_items_vl.organization_id%TYPE)
1327: RETURN mtl_system_items_vl.concatenated_segments%TYPE
1328: IS
1329:

Line 1326: p_org_id IN mtl_system_items_vl.organization_id%TYPE)

1322: -- EXAMPLE
1323: --
1324: FUNCTION Get_Item_Name(
1325: p_item_id IN mtl_system_items_vl.inventory_item_id%TYPE,
1326: p_org_id IN mtl_system_items_vl.organization_id%TYPE)
1327: RETURN mtl_system_items_vl.concatenated_segments%TYPE
1328: IS
1329:
1330: CURSOR c_item_name IS

Line 1327: RETURN mtl_system_items_vl.concatenated_segments%TYPE

1323: --
1324: FUNCTION Get_Item_Name(
1325: p_item_id IN mtl_system_items_vl.inventory_item_id%TYPE,
1326: p_org_id IN mtl_system_items_vl.organization_id%TYPE)
1327: RETURN mtl_system_items_vl.concatenated_segments%TYPE
1328: IS
1329:
1330: CURSOR c_item_name IS
1331: SELECT msi.concatenated_segments

Line 1332: FROM mtl_system_items_vl msi

1328: IS
1329:
1330: CURSOR c_item_name IS
1331: SELECT msi.concatenated_segments
1332: FROM mtl_system_items_vl msi
1333: WHERE msi.inventory_item_id = p_item_id
1334: AND msi.organization_id = p_org_id;
1335:
1336: l_item_name mtl_system_items_vl.concatenated_segments%TYPE;

Line 1336: l_item_name mtl_system_items_vl.concatenated_segments%TYPE;

1332: FROM mtl_system_items_vl msi
1333: WHERE msi.inventory_item_id = p_item_id
1334: AND msi.organization_id = p_org_id;
1335:
1336: l_item_name mtl_system_items_vl.concatenated_segments%TYPE;
1337:
1338: BEGIN
1339: IF (p_item_id IS NOT NULL) THEN
1340: OPEN c_item_name;