DBA Data[Home] [Help]

APPS.EAM_ITEM_ACTIVITIES_PUB dependencies on MTL_SYSTEM_ITEMS

Line 110: FROM mtl_system_items msi, mtl_parameters mp

106: ELSIF (p_maintenance_object_type = 2) THEN
107: IF ((p_asset_number IS NULL) AND
108: (p_maintenance_object_id = p_asset_group_id)) THEN
109: SELECT count(*) INTO l_count_rec
110: FROM mtl_system_items msi, mtl_parameters mp
111: WHERE msi.inventory_item_id = p_asset_group_id
112: AND msi.organization_id = mp.organization_id
113: AND mp.maint_organization_id = p_organization_id;
114: END IF;

Line 216: from mtl_system_items msi, mtl_parameters mp

212: from csi_item_instances cii
213: where cii.instance_id=p_object_id;
214: elsif p_eam_item_type = 2 then
215: select count(msi.inventory_item_id) into l_count
216: from mtl_system_items msi, mtl_parameters mp
217: where msi.inventory_item_id = p_object_id
218: and msi.organization_id = mp.organization_id
219: and mp.maint_organization_id = p_organization_id
220: --and eam_item_type = p_eam_item_type

Line 247: from mtl_system_items msi, mtl_parameters mp

243: IF P_ORGANIZATION_ID IS NOT NULL AND p_inventory_item_id IS NOT NULL
244: THEN
245:
246: select count(msi.inventory_item_id) into l_count
247: from mtl_system_items msi, mtl_parameters mp
248: where msi.inventory_item_id=p_inventory_item_id
249: and msi.organization_id = mp.organization_id
250: and mp.maint_organization_id=p_organization_id
251: and eam_item_type IN (1, 3);

Line 535: from mtl_system_items

531:
532: -- Bug # 3441956
533: BEGIN
534: select eam_item_type into l_item_type
535: from mtl_system_items
536: where inventory_item_id = p_asset_activity_id
537: and organization_id = nvl(p_organization_id, organization_id)
538: AND rownum = 1;
539:

Line 720: FROM mtl_system_items_b msi, mtl_parameters mp

716: /* Template flag validation */
717: begin
718: SELECT msi.eam_item_type , msi.serial_number_control_code
719: INTO l_item_type , l_ser_num_ctrl_cd
720: FROM mtl_system_items_b msi, mtl_parameters mp
721: WHERE msi.organization_id = mp.organization_id
722: AND mp.maint_organization_id = nvl(l_org_id, mp.maint_organization_id)
723: AND msi.inventory_item_id = l_asset_group_id
724: AND rownum = 1;

Line 1299: FROM mtl_system_items_b msi, mtl_parameters mp

1295: begin
1296:
1297: SELECT msi.eam_item_type , msi.serial_number_control_code
1298: INTO l_item_type , l_ser_num_ctrl_cd
1299: FROM mtl_system_items_b msi, mtl_parameters mp
1300: WHERE msi.organization_id = mp.organization_id
1301: AND mp.maint_organization_id = nvl(l_org_id, mp.maint_organization_id)
1302: AND msi.inventory_item_id = l_asset_group_id
1303: AND rownum = 1;