DBA Data[Home] [Help]

APPS.AHL_RA_NR_PROFILE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 778: FROM mtl_system_items_kfv

774:
775: CURSOR get_inventory_item_id(c_item_name VARCHAR2)
776: IS
777: SELECT inventory_item_id
778: FROM mtl_system_items_kfv
779: WHERE concatenated_segments = c_item_name;
780:
781: CURSOR check_inventory_item_id(c_iteme_id NUMBER)
782: IS

Line 784: FROM mtl_system_items_kfv

780:
781: CURSOR check_inventory_item_id(c_iteme_id NUMBER)
782: IS
783: SELECT 'X'
784: FROM mtl_system_items_kfv
785: WHERE inventory_item_id = c_iteme_id;
786:
787: CURSOR get_uom_code(c_uom VARCHAR2)
788: IS