APPS.CSE_COST_COLLECTOR dependencies on MTL_SYSTEM_ITEMS

Line 133: FROM mtl_system_items_kfv

129: AND project_id = l_source_project_id;
130:
131: CURSOR item_name_cur (p_item_id IN NUMBER, p_organization_id IN NUMBER) IS
132: SELECT concatenated_segments
133: FROM mtl_system_items_kfv
134: WHERE inventory_item_id = p_item_id
135: AND organization_id = p_organization_id;
136:
137: CURSOR gl_date_cur (l_organization_id IN NUMBER, l_acct_period_id IN NUMBER) IS

Line 151: l_item_name mtl_system_items.segment1%TYPE;

147: l_org_name hr_all_organization_units.name%TYPE;
148: l_project_number pa_projects_all.segment1%TYPE;
149: l_task_number pa_tasks.task_number%TYPE;
150: l_eib_trackable_flag VARCHAR2(5);
151: l_item_name mtl_system_items.segment1%TYPE;
152: l_exp_item_date DATE ;
153: l_exp_end_date DATE ;
154: l_gl_date DATE ;
155: l_eib_installed VARCHAR2(1);

Line 484: l_item_name mtl_system_items_kfv.concatenated_segments%TYPE;

480: WHERE hoc.organization_id = c_org_id
481: AND ho.organization_id = hoc.business_group_id ;
482: l_Business_Group_rec c_Business_Group_cur%ROWTYPE;
483:
484: l_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
485: l_serial_number VARCHAR2(30);
486: l_project_id NUMBER;
487: l_task_id NUMBER;
488: l_ref_suffix NUMBER;

Line 554: FROM mtl_system_items_kfv

550: IF l_redeploy_flag = 'N' AND l_depreciable = 'N' THEN
551: IF i = 1 THEN
552: SELECT concatenated_segments
553: INTO l_item_name
554: FROM mtl_system_items_kfv
555: WHERE inventory_item_id = csi_pending_txn_rec.inventory_item_id
556: AND organization_id = csi_pending_txn_rec.inv_master_organization_id
557: AND ROWNUM = 1;
558: END IF ;