APPS.CSE_COST_COLLECTOR dependencies on MTL_SYSTEM_ITEMS_KFV

Line 146: FROM mtl_system_items_kfv

142: AND project_id = l_source_project_id;
143:
144: CURSOR item_name_cur (p_item_id IN NUMBER, p_organization_id IN NUMBER) IS
145: SELECT concatenated_segments
146: FROM mtl_system_items_kfv
147: WHERE inventory_item_id = p_item_id
148: AND organization_id = p_organization_id;
149:
150: CURSOR gl_date_cur (l_organization_id IN NUMBER, l_acct_period_id IN NUMBER) IS

Line 497: l_item_name mtl_system_items_kfv.concatenated_segments%TYPE;

493: WHERE hoc.organization_id = c_org_id
494: AND ho.organization_id = hoc.business_group_id ;
495: l_Business_Group_rec c_Business_Group_cur%ROWTYPE;
496:
497: l_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
498: l_serial_number VARCHAR2(30);
499: l_project_id NUMBER;
500: l_task_id NUMBER;
501: l_ref_suffix NUMBER;

Line 567: FROM mtl_system_items_kfv

563: IF l_redeploy_flag = 'N' AND l_depreciable = 'N' THEN
564: IF i = 1 THEN
565: SELECT concatenated_segments
566: INTO l_item_name
567: FROM mtl_system_items_kfv
568: WHERE inventory_item_id = csi_pending_txn_rec.inventory_item_id
569: AND organization_id = csi_pending_txn_rec.inv_master_organization_id
570: AND ROWNUM = 1;
571: END IF ;