DBA Data[Home] [Help]

APPS.EAM_SRAPPROVAL_PVT dependencies on MTL_SYSTEM_ITEMS

Line 23: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%type;

19: l_owning_department_code bom_departments.department_code%type;
20: l_owning_department_role varchar2(80);
21: l_inventory_item_id cs_incidents_all_b.inventory_item_id%type;
22: l_maintenance_flag varchar2(1);
23: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%type;
24: l_conc_segments_description mtl_system_items.description%type;
25:
26: l_role_name varchar2(80);
27:

Line 24: l_conc_segments_description mtl_system_items.description%type;

20: l_owning_department_role varchar2(80);
21: l_inventory_item_id cs_incidents_all_b.inventory_item_id%type;
22: l_maintenance_flag varchar2(1);
23: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%type;
24: l_conc_segments_description mtl_system_items.description%type;
25:
26: l_role_name varchar2(80);
27:
28: l_organization_code org_organization_definitions.organization_code%type;

Line 101: from csi_item_instances cii, mtl_system_items_kfv msik, mtl_system_items msi

97: -- if Asset Number is specified on Service Request
98: if (l_instance_id is not null) then
99: select instance_number,instance_description,concatenated_segments,msi.description
100: into l_instance_number,l_instance_description,l_concatenated_segments,l_conc_segments_description
101: from csi_item_instances cii, mtl_system_items_kfv msik, mtl_system_items msi
102: where cii.last_vld_organization_id = msi.organization_id
103: and cii.inventory_item_id = msi.inventory_item_id
104: and msi.organization_id = msik.organization_id
105: and msi.inventory_item_id = msik.inventory_item_id

Line 113: from mtl_system_items_kfv msik, mtl_system_items msi

109: -- if only Asset Group is specified and asset number is not
110: elsif (l_instance_id is null AND l_inventory_item_id is not null) then
111: select msik.concatenated_segments,msik.description
112: into l_concatenated_segments,l_conc_segments_description
113: from mtl_system_items_kfv msik, mtl_system_items msi
114: where msi.organization_id = msik.organization_id
115: and msi.inventory_item_id = msik.inventory_item_id
116: and msi.inventory_item_id = l_inventory_item_id
117: and msi.organization_id = l_maint_organization_id;

Line 296: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%type;

292: l_owning_department_code bom_departments.department_code%type;
293: l_owning_department_role varchar2(80);
294: l_inventory_item_id cs_incidents_all_b.inventory_item_id%type;
295: l_maintenance_flag varchar2(1);
296: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%type;
297: l_conc_segments_description mtl_system_items.description%type ;
298:
299: l_role_name varchar2(80);
300:

Line 297: l_conc_segments_description mtl_system_items.description%type ;

293: l_owning_department_role varchar2(80);
294: l_inventory_item_id cs_incidents_all_b.inventory_item_id%type;
295: l_maintenance_flag varchar2(1);
296: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%type;
297: l_conc_segments_description mtl_system_items.description%type ;
298:
299: l_role_name varchar2(80);
300:
301: l_organization_code org_organization_definitions.organization_code%type;