APPS.CSE_COST_COLLECTOR dependencies on MTL_SYSTEM_ITEMS

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 164: l_item_name mtl_system_items.segment1%TYPE;

160: l_org_name hr_all_organization_units.name%TYPE;
161: l_project_number pa_projects_all.segment1%TYPE;
162: l_task_number pa_tasks.task_number%TYPE;
163: l_eib_trackable_flag VARCHAR2(5);
164: l_item_name mtl_system_items.segment1%TYPE;
165: l_exp_item_date DATE ;
166: l_exp_end_date DATE ;
167: l_gl_date DATE ;
168: l_eib_installed VARCHAR2(1);

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 ;