DBA Data[Home] [Help]

APPS.DPP_CLAIMS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 188: FROM mtl_system_items_kfv

184:
185: CURSOR get_item_number_csr(p_item_id NUMBER) IS
186: SELECT DISTINCT concatenated_segments item_number,
187: description
188: FROM mtl_system_items_kfv
189: WHERE inventory_item_id = p_item_id;
190:
191: CURSOR get_claim_number_csr(p_claim_id NUMBER) IS
192: SELECT claim_number

Line 452: FROM mtl_system_items_kfv

448: END IF;
449: --Get the item description
450: SELECT DISTINCT description
451: INTO l_item_description
452: FROM mtl_system_items_kfv
453: WHERE inventory_item_id = l_txn_line_tbl(i).Inventory_Item_Id;
454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN
456: ROLLBACK TO CREATE_CLAIMS_PVT;