DBA Data[Home] [Help]

APPS.DPP_CLAIMS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 194: FROM mtl_system_items_kfv

190:
191: CURSOR get_item_number_csr(p_item_id NUMBER) IS
192: SELECT DISTINCT concatenated_segments item_number,
193: description
194: FROM mtl_system_items_kfv
195: WHERE inventory_item_id = p_item_id;
196:
197: CURSOR get_claim_number_csr(p_claim_id NUMBER) IS
198: SELECT claim_number

Line 463: FROM mtl_system_items_kfv

459: END IF;
460: --Get the item description
461: SELECT DISTINCT description
462: INTO l_item_description
463: FROM mtl_system_items_kfv
464: WHERE inventory_item_id = l_txn_line_tbl(i).Inventory_Item_Id;
465: EXCEPTION
466: WHEN NO_DATA_FOUND THEN
467: ROLLBACK TO CREATE_CLAIMS_PVT;